Graham Anderson <[EMAIL PROTECTED]> wrote on 03/23/2005 06:19:34 PM:
> stupidly
> My DateTime field is in this format:
> March 23, 2005, 3:49 pm
>
> If I want to run this sql
> SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
> FROM userLog
>
> I gather I need some extr
stupidly
My DateTime field is in this format:
March 23, 2005, 3:49 pm
If I want to run this sql
SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
FROM userLog
I gather I need some extra function like..
SELECT TO_DAYS(MAX(Convert _Function(DateTime))) -
TO_DAYS(MIN(Conv