Re: ISO time zone format

Sabin Coanda wrote:
>
> I'd just like to format it independent of my DateStyle. Some timestamp parts
> may be formatted this way.
>
> For instance I can format ISO date with to_char( dt, 'YYYY-MM-DD'), and ISO
> time with to_char( dt, 'HH24:MI:SS') as well. I'd just like to find the
> format pattern for the ISO time zone (numeric).

Hmm - we don't seem to support those codes (TZH, TZM) for some reason.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#sthref405

But it seems the developers know about it:
http://www.postgresql.org/docs/faqs.TODO.html
http://archives.postgresql.org/pgsql-hackers/2005-12/msg00948.php

If you know a little bit of "C" then you should be able to submit a
patch for this without too much trouble.

For the moment, you'll have to use extract() to pick out the bit(s) you
need:
to_char(extract(timezone_hour from current_timestamp), 'S00');

HTH
--
Richard Huxton
Archonet Ltd