Storing DateTimes in Databases

[egon010]

I had a discussion a while back about timezones and storing DateTimes in databases. I had wanted to standardize everything to UTC, since you lose timezone data -- is it PST or PDT? How do you convert the date if it needs to be displayed to a client not in your timezone? Well, it's come 'round, and is going to bite the ruby folks.

Rails 2.1 timezone support