Paul Hastings wrote:
> Rick Root wrote:
>
>>Coldfusion inserts a UTC timestamp into the database which is returned
>
>
> is the server tz UTC? if notm then i bet you it doesn't ;-) well at
> least a couple of times a year it doesn't.
It does when you use dateConvert('local2utc',Now())
Doesn't it?
Rey Bango wrote:
> Take a look at this Rick to see if this helps:
>
>
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt157.htm
Already doing that =)
> You might also want to take a look at this page:
>
> http://www.elated.com/tutorials/programming/javascript/dates/
>
> Search for the phrase "About UTC".
I've seen that page but unfortunately since javascript already thinks my
date is EST, if I use those UTC functions, it's going to offset them by
6 hours or something like that.
I think what I might have to do is store the dates in UTC string format,
rather than as datetime stamps in the database. That way javascript can
more easily interpret them as UTC strings, not date objects, and I can
convert them from strings to date objects in the javascript.
Rick
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252590
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
