Re: BUG #14558: to_timestamp() format lies about supporting timezone

On Mon, Feb 20, 2017 at 8:40 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> writes:
> > On Mon, Feb 20, 2017 at 8:11 AM, <coladict(at)gmail(dot)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