Store all datetimes in UTC in the db. Use Timezone.cfc to cast to/from UTC. http://timezonecfc.riaforge.org/
Judah On Tue, Aug 24, 2010 at 12: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:325850 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
