Dealing with time zones was a major PITA a recent project I did.
Eventually I decided to store all dates in UTC and format them as needed
for the current user. This made it much easier to deal with those
dreaded daylight savings time shifts, when local time jumps around and
offsets just don't cut it. (My project was CF and java, and most of the
database reads were done in java. This simplified some things for me, I
think.)
So, I'd say you first big decision is whether to store dates in UTC or
not, and if you are serious about trying to make "local time" feel right
to any user then I'd say UTC is the way to do. Either way you decide,
you will probably be frustrated at some point by something that should
be easy but isn't.
Thanks
Mark
-----Original Message-----
From: Mik Muller [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 3:56 PM
To: CF-Talk
Subject: dealing with timezones
Hey,
So I'm thinking of how to deal with timezones. My server's clock is set
to US west coast time, and I serve many, many sites that are all in
different timezones. They're all running the same code which subscribes
(in a fashion) to a central application to verify the site's status.
I'm thinking of doing a s&r on "now()" and replacing it with "noww()",
which would be a UDF that would create the effective local time for that
site based upon (1) the server local time and (2) the site offset from
that local time.
Any crazy red flags anyone can think of?
Mik
--------
Michael Muller
Admin, MontagueMA.net Website
work (413) 863-0030
cell (413) 320-5336
skype: michaelBmuller
http://www.MontagueMA.net
Eschew Obfuscation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295171
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
