Re: TO_DATE Function unintended behavior when month value is greaterthan 12

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Дата
Msg-id CAFj8pRB3fp-mscbUziCdySHQhQcPkeL-ytP3oNVOZyU=WMEjvw@mail.gmail.com
обсуждение исходный текст
Ответ на TO_DATE Function unintended behavior when month value is greater than 12  (naidu rongali <rongalinaidu@gmail.com>)
Список pgsql-bugs
Дерево обсуждения


2018-03-01 19:34 GMT+01:00 naidu rongali <rongalinaidu@gmail.com>:
Hi,
I noticed this behavior on recent release of PG database. It will be helpful to users, if this behavior is looked into. 

When executed below SQL, got unintended output when i expected it to throw error " not a valid month "

SQL executed:
select to_date('20171231','YYYYDDMM')

result:
2019-07-17

What is your version?

It should be fixed on PostgreSQL 10 and higher (there was not backport because some applications used this feature)

Regards

Pavel



 


Thank you, Naidu

В списке pgsql-bugs по дате отправления:

Предыдущее
От: naidu rongali
Дата:
Сообщение: TO_DATE Function unintended behavior when month value is greater than 12
Следующее
От: Igor Neyman
Дата:
Сообщение: RE: TO_DATE Function unintended behavior when month value is greaterthan 12