Horton

Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Aleksander Alekseev <a.alekseev@postgrespro.ru>
Cc: 甄明洋 <zhenmingyang@yeah.net>, pgsql-bugs <pgsql-bugs@postgresql.org>
Date: 2016-08-04T15:06:40Z
Lists: pgsql-bugs 
On Thu, Aug 4, 2016 at 11:03 AM, Aleksander Alekseev <
a.alekseev@postgrespro.ru> wrote:

> >> postgres=# select to_timestamp('1990-1-1 11:11:11.123456789',
> >> 'YYYY-MM-DD HH24:MI:SS.US'); to_timestamp
> >> -------------------------------
> >>  1990-01-01 11:13:14.456789+08
> >> (1 row)
> >> postgres=#
>
> > ​Working as designed...​
>
> Maybe it means that current design is poor. However since this behavior
> is documented there are users who might depend on it. So I doubt it
> will be changed any time soon.
>
> Though I wonder maybe we should consider introducing a new set of
> time-related procedures with different behavior (to_timestamp_strict?),
> that would be more obvious to users.
>

​
Discussions ongoing...
​an archive search should be fruitful.

David J.
​
​