date function bug

[Abraham, Danny]

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)