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. So even though you say ignore that, you can't because the system doesn't ignore it.
Steve -----Original Message----- From: Tom McNeer [mailto:[email protected]] Sent: Wednesday, April 21, 2010 5:13 PM To: cf-talk Subject: Re: DateAdd value different on different servers Thanks for the replies, but mainly they tell me that I've muddied the water. Let me try to be clearer: I shouldn't have even mentioned the Unix value, because that's not relevant. Just forget that I'm getting a Unix value completely. And I definitely should not have shown the time zones, because they shouldn't be relevant. So let me start over. Forget everything but the following: First, I'm saying, "Create a date/time value for January 1, 1970." myDate = createDate(1970,1,1) That's going to result in an object that represents midnight on 1/1/1970. Doesn't even matter that it's the epoch date. Then I'm adding a number of seconds: myDate2 = DateAdd('s',1271779666,myDate) When these two values are dumped, two servers show the following: {ts '1970-01-01 00:00:00'} {ts '2010-04-20 17:07:46'} One server shows this: {ts '1970-01-01 00:00:00'} {ts '2010-04-20 16:07:46'} ===================== So - we're not dealing with time zones. We're simply creating date/time values. Why does the result of the dateAdd function return different values? That's the real issue. Sorry for being so confusing before. -- 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:333082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
