Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Time Zone Issues
... or maybe just a TimeZone history would be enough. Store the dates in UTC and keep track of when the TimeZone setting changes. When you want to display a date, check against the time zone history to pick the time zone that was set at the specified date. just sharing my thoughts, Rémi- remid
- Post #6
- Forum: General e-Business discussion
-
Time Zone Issues
Hi guys, storing in UTC with a TimeZone setting for each user as fhlee suggested is a good solution but only when, in time, a user does not change this setting. If the TimeZone setting changes, the timestamp of a transaction changes also. The only thing I can think of is keeping a transaction...- remid
- Post #5
- Forum: General e-Business discussion
