Hi, The operating system I run (Linux) comes with many, many timezone files for many different places in the world. For example:
$ TZ='Australia/Sydney' date Fri Oct 8 06:15:31 EST 2004 $ TZ='Europe/Amsterdam' date Thu Oct 7 22:15:38 CEST 2004 $ TZ='Africa/Bissau' date Thu Oct 7 20:18:44 GMT 2004 $ TZ='America/Phoenix' date Thu Oct 7 13:19:33 MST 2004 Is there any way I can use these from within postgresql? Those files contains details about daylight saving changes and other useful details like that, which a simple PST or EST won't cover. Or should I simply do all my date/time conversion in my application? Any ideas? -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpVE9TnKICrE.pgp
Description: PGP signature
