By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,933 Members | 1,574 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,933 IT Pros & Developers. It's quick & easy.

determining supported timezones

P: n/a
I am trying to figure out if there is a way to determine the timezones
supported in postgresql from within the database. If you look at
http://www.postgresql.org/docs/7.4/s...-keywords.html it
notes that time zone information is system dependent, (I interpret to
mean that anything I find in /usr/share/zoneinfo on linux should be
supported, can someone confirm that?) so how can an external app
determine which timezones are supported given that it could be deployed
against postgresql databases on different OS's. My current thinking is
that there is no way to get a complete list, but perhaps the list of
known timezones (as listed in the docs) are available? If it is not,
will this change in 7.5 now that we have a standard timezone library we
are using across platforms?

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.