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: 20101017152320.GA13439@depesz.com (view raw or flat)
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
http://www.postgresql.org/docs/current/interactive/functions-formatting.html
doc, that you can't use TZ (and some other patterns too)?

Best regards,

depesz

-- 
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

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-2014 The PostgreSQL Global Development Group