ColdFusion Timezone Support?

Question

Does ColdFusion 8 have any built-in support for handling timezones? We'd like our users to be able to choose a timezone and then have all dates/times on the site adjusted to their locale. Currently we're asking users to set an offset from server time, and it's a headache because they have to go in a couple times each year and manually adjust for daylight savings time.

We're running CF8 on Windows and all dates/times are stored in SQL Server 2005 in Pacific Time. So when Windows auto-adjusts the local clock between Daylight and Standard time, a certain number of our users need to adjust their offset from server time.

I've looked through the International Functions, and none of them seem to convert between timezones. We don't want to turn to a Web Service to get offset/daylight info if it's built into the JVM, and ideally we'd stick with CF functions if they're available. Seems like a common need so I'm surprised there's nothing built into CF to handle this. Is there?

Answer 1

GetTimeZoneInfo() will tell you if daylight saving time is currently in effect on the server, you could use this information along with a checkbox for DST when the user selects their server time offset.

Answer 2

http://stackoverflow.com/questions/795615/how-to-handle-timezones-in-cfml :)