Date column blank

HI Team

i have a table with date column data type. when some inserted wrong date type it is storing as blank value with a length of 17 characters i.e

insert into upload_master(id,manual_supp_date) values(1,‘2020-17-17’);

i need to validate these kind of values can some give some comments…


It’s usually best to catch these errors early so bad data doesn’t get into the table. Be sure to set data_conversion_compatibility_level to the highest supported level.

The default is old and too permissive.