From: | "Alexander Loechel" <Alexander(dot)Loechel(at)unibw(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5714: TZ pattern error on to_timestamp |
Date: | 2010-10-17 11:49:45 |
Message-ID: | 201010171149.o9HBnjH6011355@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5714
Logged by: Alexander Loechel
Email address: Alexander(dot)Loechel(at)unibw(dot)de
PostgreSQL version: 8.4.5
Operating system: Ubuntu Server 10.04. LTS
Description: TZ pattern error on to_timestamp
Details:
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"
I guess this behaviour is not intended as chapter 9.9 of the manual allows a
TZ pattern on to_timestamp().
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-17 15:10:09 | Re: BUG #5714: TZ pattern error on to_timestamp |
Previous Message | Alvaro Herrera | 2010-10-17 03:18:24 | Re: BUG #5713: lo_export |