Re: [BUGS] BUG #14558: to_timestamp() format lies about supporting timezone
| От | John McKown |
|---|---|
| Тема | Re: [BUGS] BUG #14558: to_timestamp() format lies about supporting timezone |
| Дата | |
| Msg-id | CAAJSdjjhdd2J3rUqMXuuJ2yBL+d6mVfTU0XsQ8xW4+fgdoQBbA@mail.gmail.com обсуждение исходный текст |
| Ответ на | [BUGS] BUG #14558: to_timestamp() format lies about supporting timezone (coladict@gmail.com) |
| Ответы |
Re: [BUGS] BUG #14558: to_timestamp() format lies about supporting timezone
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14558
Logged by: Jordan Gigov
Email address: coladict@gmail.com
PostgreSQL version: 9.6.2
Operating system: irrelevant
Description:
postgres=# SELECT to_timestamp('2017-02-20 16:00:27.989808+02', 'YYYY-MM-DD
HH24:MI:SS.SSSSOF')::timestamp with time zone;
ERROR: "TZ"/"tz"/"OF" format patterns are not supported in to_date
I'm not a maintainer. Or any kind of an official "expert". But I'm wondering if the above is really a bug. From reading the documentation on: https://www.postgresql.org/docs/current/static/functions-datetime.html, it seems to me to say that to_timestamp() only takes one parameter, which is a double precision number (not a string). But the following worked well for me:
tsh009=# SELECT '2017-02-20 16:00:27.989808+02'::timestamp;
timestamp
----------------------------
2017-02-20 16:00:27.989808
(1 row)
timestamp
----------------------------
2017-02-20 16:00:27.989808
(1 row)
Or was this an enhancement request?
"Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion
Maranatha! <><
John McKown
John McKown
В списке pgsql-bugs по дате отправления: