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 | CAAJSdjjGKwweKY8VSUV6Szimy6y2EA3duFfx6CTXpFeE+m4fGg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [BUGS] BUG #14558: to_timestamp() format lies about supporting timezone (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-bugs |
John McKown <john.archie.mckown@gmail.com> writes:
> On Mon, Feb 20, 2017 at 8:11 AM, <coladict@gmail.com> wrote:
>> 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).
Nah, that's the other function named to_timestamp. This one's documented
on the previous page:
https://www.postgresql.org/docs/current/static/functions- formatting.html
See, I told ya'll that I'm not an expert. And thus it is shown! And in a kindly manner.
regards, tom lane
"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 по дате отправления: