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)