Possibly because createodbcdate('12 March 2004') defaults to midnight, and
now() retains the time today aswell, I just tried it and it's about 10:30,
with the difference being 38000 secs, which looks about right?
----- Original Message -----
From: "Justin Mclean" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, March 12, 2004 10:32 AM
Subject: [cfaussie] CF Date bug???
> Hi there,
>
> Anyone know why the difference between these two dates are not 0 when both
> of them have the value "{d '2004-03-12'}"?
>
> <cfset time1 = createodbcdate('12 March 2004')>
> <cfset time2 = createodbcdate(now())>
> #time1#<br>
> #time2#<br>
> #datediff("s",time1, time2)#<br>
>
>
> Justin
> =============================================
> Justin Mclean Class Software
> Phone: (02) 93321230 9 Chapman St
> Fax: (02) 93321032 Surry Hills
> Mobile: 0416 119 342 NSW 2010
> =============================================
>
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
>
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004