How do you handle Timezone info for Datetime and DST.

I was thinking of putting everything into the database as utc(gmt) and adjusting it on the local machine. but 2 machines in two different timezones will give me two differnent numbers. (i think).

Do i store timezone info in the database too in a seperate field?

John

I've got some TimeZone issues that I have been putting off for a while and I read a very informative article a while back but not sure the exact link. However, I did just run across this blog entry that consolidates the links to several different articles: http://geekswithblogs.net/mtreadwell/archive/2004/05/21/5214.aspx

As with all things, what appears to be an easy issue on the surface turns into a complex issue once you get into all the details.

Hope the link helps.