On Dec 24, 2008, at 3:43 AM, Roy Lyseng wrote:
Unfortunately, 4 bits is too small for a time-zone specification (unless you allow maximum 16 timezones to be used ;) So a timestamp WITH time zone probably has to go in more than 8 bytes.
I am not a fan of keeping TZ information as a deep part of the server. The complexity of the Olson TZ database coding system and database is on it's face evidence that TZ stuff should be data driven, external, and part of presentation layers, not storage layers. Keep all dates inside the db in UTC and be done with it.
-- Mark Atwood <http://mark.atwood.name> _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
