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.kla...@aklaver.com
