Timezone template for to_char(timestamp, '...')?

From: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Timezone template for to_char(timestamp, '...')?
Date: 2000-06-29 19:32:23
Message-ID: 00062915400003.00209@comptechnews
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2000-06-29 21:58:43 Re: Publishing my book
Previous Message Tom Lane 2000-06-29 19:30:04 Re: pg_dump/load quoting.