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 по дате отправления: