Re: to_char timezone - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: to_char timezone
Date
Msg-id 20121105212744.GF19099@momjian.us
Whole thread Raw
In response to to_char timezone  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Sun, Oct 21, 2012 at 05:40:40PM -0400, Andrew Dunstan wrote:
> 
> I'm not sure if this has come up before.
> 
> A client was just finding difficulties because to_char() doesn't
> support formatting the timezone part of a timestamptz numerically
> (i.e. as +-hhmm) instead of using a timezone name. Is there any
> reason for that? Would it be something worth having?

Yes, it is odd it is missing, and would be good to have.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: alter table tablename add column - breaks pl/pgsql function returns tablename
Next
From: Bruce Momjian
Date:
Subject: Re: Pg_upgrade speed for many tables