On Thursday, Jul 3, 2003, at 06:10 US/Pacific, Tony Weeg wrote:
> 3. this is all well and fine, unless the date falls inside daylight
> savings time (any time after the 1st Sunday in April) whereby CFMX adds
> 1 hour to I guess self correct for DST.

Yes, I have confirmed that when you do a dateAdd() of seconds since the 
epoch (1/1/70) that puts you in DST, the dateAdd() adds an unexpected 
additional hour, in other words:

   <cfset theEpoch = "01-01-1970 00:00:00"/>
   <cfset secsSinceEpoch = dateDiff('s', theEpoch, someDateAndTime) />
   <cfset reconstitutedDate = dateAdd('s', secsSinceEpoch, theEpoch) />

reconstitutedDate will be one hour off from someDateAndTime if the date 
is in DST.

Sean A Corfield -- http://www.corfield.org/blog/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to