Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’
| От | David G. Johnston |
|---|---|
| Тема | Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’ |
| Дата | |
| Msg-id | CAKFQuwa1eWdO-7Y-uqRTGrdwj0H=N6iz5dLohLy7BCeLG3=qrw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Re: [BUGS] Return value error of‘to_timestamp’ (Aleksander Alekseev <a.alekseev@postgrespro.ru>) |
| Ответы |
Re:Re: Re: [BUGS] Return value error of‘to_timestamp’
|
| Список | pgsql-bugs |
>> 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 по дате отправления: