Matthew wrote: > Ahh. And we have customers all over the world. Dang. See, all of this > programming was done back shortly after we "sprang forward" so we > didn't think about it. > > Any suggestions on how I should store a customers timezone in > database?
I think the best way is probably using the Olson time zone name. These are names like 'America/New_York' and 'Australia/Melbourne'. http://www.twinsun.com/tz/tz-link.htm Perl's DateTime module uses these time zones, as do MySQL >= 4.1.3 and Oracle >= 9i. Regards, Philip