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

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема RE: TO_DATE Function unintended behavior when month value is greaterthan 12
Дата
Msg-id CO2PR17MB0058CA3B1C32ECCEBAC4BD66DAC60@CO2PR17MB0058.namprd17.prod.outlook.com
обсуждение исходный текст
Ответ на TO_DATE Function unintended behavior when month value is greater than 12  (naidu rongali <rongalinaidu@gmail.com>)
Ответы Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Список pgsql-bugs
Дерево обсуждения

 

From: naidu rongali [mailto:rongalinaidu@gmail.com]
Sent: Thursday, March 01, 2018 1:34 PM
To: pgsql-bugs@postgresql.org
Subject: TO_DATE Function unintended behavior when month value is greater than 12

 

Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails.

 

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

 

 

Thank you, Naidu

 

I get this:

ERROR: date/time field value out of range: "20171231" SQL state: 22008

 

Regards,

Igor Neyman

 

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Следующее
От: Pantelis Theodosiou
Дата:
Сообщение: Re: TO_DATE Function unintended behavior when month value is greaterthan 12