Re: [HACKERS] Outputting UTC offset with to_char()

2013-07-01 Thread Bruce Momjian
Applied. I referenced macros for some of the new constants, e.g. SECS_PER_HOUR. --- On Fri, Jun 28, 2013 at 10:04:49PM -0400, Bruce Momjian wrote: > On Sun, Oct 21, 2012 at 05:40:40PM -0400, Andrew Dunstan wrote: > > > > I

[HACKERS] Outputting UTC offset with to_char()

2013-06-28 Thread Bruce Momjian
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