[thelist] web and db server local time

kasimir-k kasimir.k.lists at gmail.com
Sun Nov 18 07:38:05 CST 2007


Joel D Canfield scribeva in 16/11/2007 22:06:
> yeah; I'll timestamp local and adjust in the display.

I'd recommend saving time in UTC (Time formerly known as Greenwich Mean
Time (GMT)). That way you'll ever only to have figure out client's time
zone (with javascript or the user choosing their time zone). If you save
your times in any other than UTC, then you'll have to worry both the
server's and client's time zones. Also dealing with DST is much easier
if you store UTC.

.k




More information about the thelist mailing list