BUG #5714: TZ pattern error on to_timestamp
От | Alexander Loechel |
---|---|
Тема | BUG #5714: TZ pattern error on to_timestamp |
Дата | |
Msg-id | 201010171149.o9HBnjH6011355@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5714: TZ pattern error on to_timestamp
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5714 Logged by: Alexander Loechel Email address: Alexander.Loechel@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().
В списке pgsql-bugs по дате отправления: