On 2/16/13 5:00 AM, Ted Roche wrote: > In addition, few DBMS do a good job of tracking timezones. TZ are a hard > problem, as there are dozens of changes to what location has which timezone > every year, so it's difficult to calculate if it is not captured at the > time.
Why would the DBMS need to know anything about the TZ? That's up to the client side for display purposes, no? IOW, all datetimes are saved in the backend as UTC. The client (who knows his TZ and offset) can display the localized datetime. Paul _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5121373f.1000...@ulmcnett.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.