TimeZone List - Mailing list pgsql-general

From Naz Gassiep
Subject TimeZone List
Date
Msg-id 465CB73B.2040004@mira.net
Whole thread Raw
Responses Re: TimeZone List
List pgsql-general
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 OSes
may cause some listed timezones to disappear or change name, causing
havoc for any entries in the DB referring to those zones.

Is relying on zone.tab to be a non-volatile list of timezones
appropriate for this purpose? Or is there an ISO listing of the various
time zones? I would prefer to use a list that matched the PostgreSQL
DB's internal timezone strings so they could easily be referenced
without any further work in the app.

Thanks
- Naz.

pgsql-general by date:

Previous
From: Tom Allison
Date:
Subject: prepare()
Next
From: "Hale Boyes, Kevin "
Date:
Subject: Re: 8.3