Time stamps and time zones

I'm working on time - and here's what I've come up with as a best practice: * allow handling of timezones and time stamp storage to be configurable, defaulting to simple local time* I'll store timestamp in YYYY-MM-DD HH:MM:SS (or unix epoch) in the database at UTC, then convert to localtime using Nexista actions - why? Because its the only real consistent, simple, and straightforward way I could figure out how to convert unix timestamps, date time stamps, and timezones. * I'm currently getting the timezone from the the user when they login or a session is started from javascript, however I'd like to make this user configurable
By Albert on March 9, 2008 1:05 PM