Shawn McKee wrote: > I have applications that deliver content in a time sensitive manner. We > store times in our database in UTC (GMT). Whenever a country changes from > or to standard time I catch a lot of grief because release times have to be > manually updated. Anybody know of a tool, CF or otherwise, that can help me > solve the problem of update the UTC stored based on some sort of location > parameter.
The SQL standard says that it should be possible to do: SELECT [column] WITH TIMEZONE [timezone] AS alias If your database implements this it might be an easy way out. Jochem ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
