On 10/23/19 7:22 AM, Abraham, Danny wrote:
Hi,
The function "to_date" does not fail illegal values.
Is this a known bug?
What is the recommended type checking?
ctrlmdb=> select to_date('2018100X','YYYYMMDD');
to_date
------------
2018-10-01
(1 row)
At: https://www.postgresql.org/docs/11/functions-formatting.html I would read the section starting : "Usage notes for date/time formatting: ..." several times. There a lot of 'if and or buts' in there. -- Adrian Klaver adrian.klaver@xxxxxxxxxxx
