I need to use dateConvert to account for daylight savings time :) thanks!
tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 4:02 PM To: CF-Talk Subject: Re: cfmx error? (happens on redsky beta 2 as well) ---------- Original Message ---------------------------------- From: "Tony Weeg" <[EMAIL PROTECTED]> ><cfoutput>#DateDiff('s','01/01/1970 00:00:00.000',Now())#</cfoutput> > >try it for yourself, you'll end up with a number like 1056986141 which >was when I was typing this, now, turn that into a date time combo.... I >get this... 06/30/2003 16:15:41 which is by my >counting 1 hour faster than it actually is now!!!!!! WTH? > How are ou turning that number back into a date-time combo? Are you taking into account that a year is 365.25 days and not 365? When I try something like comparing Now() with noon on 6/30/1970 (so it's easier for me to compare) and then figuring out the different date parts [how many years, days, hours, minutes, seconds] difference there is, I get the right number for the hours and minutes. (right now -- 2 hours) So, it seems to work right for me. Scott -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
