From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Alexander Loechel" <Alexander(dot)Loechel(at)unibw(dot)de> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5714: TZ pattern error on to_timestamp |
Date: | 2010-10-17 15:10:09 |
Message-ID: | 9455.1287328209@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"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.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2010-10-17 15:23:20 | Re: BUG #5714: TZ pattern error on to_timestamp |
Previous Message | Alexander Loechel | 2010-10-17 11:49:45 | BUG #5714: TZ pattern error on to_timestamp |