Timezone template for to_char(timestamp, '...')? - Mailing list pgsql-general

From Robert B. Easter
Subject Timezone template for to_char(timestamp, '...')?
Date
Msg-id 00062915400003.00209@comptechnews
Whole thread Raw
Responses Re: Timezone template for to_char(timestamp, '...')?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
I'm using

    to_char(timestamp, 'Dy @MM:MIAM, Mon DD, YYYY')

to format a timestamp and its works fine except I'd like to add the timezone
(EDT etc) to the end.

Is there a format template for timezone?  I thought TZ might be it, but it
doesn't work.

The documentation for to_char() is here:
http://www.postgresql.org/docs/postgres/x2976.htm

--
Robert B. Easter

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump/load quoting.
Next
From: Fred_Zellinger@seagate.com
Date:
Subject: Large Tables(>1 Gb)