Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’ - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’
Date
Msg-id CAKFQuwa1eWdO-7Y-uqRTGrdwj0H=N6iz5dLohLy7BCeLG3=qrw@mail.gmail.com
Whole thread Raw
In response to Re: Re: [BUGS] Return value error of‘to_timestamp’  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Responses Re:Re: Re: [BUGS] Return value error of‘to_timestamp’  (甄明洋 <zhenmingyang@yeah.net>)
List pgsql-bugs
Tree view
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.
​
​
 

pgsql-bugs by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: Re: [BUGS] Return value error of‘to_timestamp’
Next
From: marko@joh.to
Date:
Subject: BUG #14279: Logical decoding misses a transaction completely