I have a number of timezone related issues which I’m currently confused
about.
I want to store all times in the database as UTC/GMT so that I can then
massage them to be displayed how I like at a later date.
I’m using the TZInfo class at the moment to convert timezones and to
deal with daylight savings time.
My main question is how do I ensure all data is stored as UTC when the
server will be located in the US (Dreamhost)? Calling NOW() in SQL will
use the timezone of the server, which isn’t UTC - how do I make sure
this does the ‘right thing’?
Am I going in the right direction, and how are other people dealing with
this issue?
Thanks in advance.