On 6/10/2011 11:43 AM, Ruslan Sivak wrote:
> <cfdump var="#DateDiff(s,'1/1/1970','6/1/2011')#">
1st off pretty sure s won't work, DateDiff('s','1/1/1970','6/1/2011') is the
correct syntax.
> I get 1306882800.
actually i get 1306886400, my server is in ICT timezone (tz) there's no DST
here.
if i do
createDate(2011,6,1).getTime();
i get 1306861200000 ms as the epoch offset.
all datetimes in cf are in cf's tz. so i guess you're in tz hell.
are the sql & cf servers in the same tz?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345143
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
