Yes I agree that it is just math, it is the output that is doing the conversion. The computers should be using Universal Time (Used to be Greenwich Mean Time), but whenever you display a time it converts to the local time zone. I know there is a way to display it in Universal time, but I don't remember how at the moment.
Or maybe I missed something, but the fact that it is exactly one hour off just screams time zone/daylight savings time difference. Steve -----Original Message----- From: Tom McNeer [mailto:[email protected]] Sent: Thursday, April 22, 2010 9:17 AM To: cf-talk Subject: Re: DateAdd value different on different servers Steve, On Thu, Apr 22, 2010 at 8:47 AM, DURETTE, STEVEN J (ATTASIAIT) < [email protected]> wrote: > > I believe it is doing this because even though you are adding a specific > amount of seconds the system automatically knows to make adjustments > based on its time zone or if it uses daylight savings time or not. If dateAdd worked that way, you'd have to adjust for the server time zone constantly. It doesn't. It's just math. I can confirm that two servers, both running CF9 on Windows Server 2008, both in the Eastern time zone, both recognizing that Daylight Savings Time is in effect, are returning date/time values one hour apart. Moreover, I can confirm that a server in the Central time zone, also recognizing that Daylight Savings Time is in effect, returns a date/time value that is the same as one of the EDT servers, and one hour _later_ (not earlier) than one of the EDT servers. After I've played with the JVMs, I'll report back. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
