I use UTC for ALL database stuff and then just adjust based on the locale of the user. I learned the hard way years ago when I switched hosts and they were in a different timezone. All my db transactions used getDate() (or whatever the syntax is) and it essentially broke my app in a big way.
UTC FTW! On Tue, Aug 24, 2010 at 3:28 PM, Vivec <gel21...@gmail.com> wrote: > > How do you deal with different time zones? > > The server that the application is hosted at is about two hours behind > Trinidad time. > > So say for Transactions, if a local transaction happens at 3pm, the > application stores it as taking place at 2pm. > > How do you handle that time zone difference normally? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:325851 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
