Re: [GENERAL] TimeZone List

2007-05-29 Thread Stuart Cooper
No, you can't. The reason there is no "nonvolatile" list of timezones is that timezones are subject to the whims of politicians, who can and do change them at the drop of a hat. Read the historical comments in the zic source files sometime... It used to be that "fully one third of timezones in

Re: [GENERAL] TimeZone List

2007-05-29 Thread Naz Gassiep
Tom Lane wrote: > Naz Gassiep <[EMAIL PROTECTED]> writes: > >> Ok, that's kinda cool. But can I trust those names to not change from >> version to version? >> > > No, you can't. The reason there is no "nonvolatile" list of timezones > is that timezones are subject to the whims of politicia

Re: [GENERAL] TimeZone List

2007-05-29 Thread Tom Lane
Naz Gassiep <[EMAIL PROTECTED]> writes: > Ok, that's kinda cool. But can I trust those names to not change from > version to version? No, you can't. The reason there is no "nonvolatile" list of timezones is that timezones are subject to the whims of politicians, who can and do change them at the

Re: [GENERAL] TimeZone List

2007-05-29 Thread Naz Gassiep
Alvaro Herrera wrote: > alvherre=# select * from pg_timezone_names ; >name | abbrev | utc_offset | is_dst > --+++ > Africa/Algiers | CET| 01:00:00 | f > Africa/Luanda

Re: [GENERAL] TimeZone List

2007-05-29 Thread Alvaro Herrera
Naz Gassiep wrote: > I've been trying to sort out the answer to this question for a while > now, I've received different answers from different places. > > I'm looking for a definitive non-volatile list of timezones for use in a > web application. I can't use the OS's time zone list, as changing O