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

Re: BUG #5714: TZ pattern error on to_timestamp

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Alexander Loechel" <Alexander(dot)Loechel(at)unibw(dot)de>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5714: TZ pattern error on to_timestamp
Date: 2010-10-17 15:23:20
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
On Sun, Oct 17, 2010 at 11:10:09AM -0400, Tom Lane wrote:
> "Alexander Loechel" <Alexander(dot)Loechel(at)unibw(dot)de> writes:
> > After an update on my ubuntu system of postgres 8.4.4 to 8.4.5 the
> > to_timestamp methode produces different results.
> > in a CREAT View statement I have following methode call:
> > to_timestamp(dbtimestamp, 'YYYY/MM/DD HH24:MI:SS TZ') AS "timestamp"<<
> > Where dbtimestamp is a String coming from a CMS.
> > before migration it produces normal timestamps
> > after migration I get following Message:
> > "ERROR: TZ/tz format patterns are not supported in to_date"
> Testing shows that that example fails in every Postgres release back to
> 7.1.  The spelling of the error message varies a bit, but they all agree
> that a TZ format spec isn't supported.
> I don't know what changed in your installation, but it wasn't this.

Any reason why Pg can't parse TZ?
perhaps it should be also listed in
doc, that you can't use TZ (and some other patterns too)?

Best regards,


Linkedin:  /  blog:
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2010-10-17 15:28:51
Subject: Re: BUG #5714: TZ pattern error on to_timestamp
Previous:From: Tom LaneDate: 2010-10-17 15:10:09
Subject: Re: BUG #5714: TZ pattern error on to_timestamp

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