The following bug has been logged online: Bug reference: 5714 Logged by: Alexander Loechel Email address: alexander.loec...@unibw.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(). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
