From: Lon Baker <lon@...>
Date: 2004-12-01T23:51:33+09:00
Subject: Re: Timezone Adjustment?

Thanks for the suggestions and here is what I had come up with.

The time is stored in a datetime field in MySQL. Assuming I stored it 
as UTC/GMT, when it is displayed I am simply adjusting it based on the 
users preferences, currently these are limited to US timezones.

t = time from database in UTC/GMT

t + Time.zone_offset('PST')  #displays Pacific Standard Time
t + Time.zone_offset('MST')  #displays Mountain Standard Time
t + Time.zone_offset('CST')  #displays Central Standard Time
t + Time.zone_offset('EST')  #displays Eastern Standard Time

--
Lon