Skip site navigation (1) Skip section navigation (2)

Re: to_char timezone

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: to_char timezone
Date: 2012-11-05 21:27:44
Message-ID: 20121105212744.GF19099@momjian.us (view raw or flat)
Thread:
Lists: 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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2012-11-05 21:29:49
Subject: Re: Pg_upgrade speed for many tables
Previous:From: Jeff JanesDate: 2012-11-05 21:23:58
Subject: Re: Pg_upgrade speed for many tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group