Date column blank

Help Procedural SQL
1

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…

form1

2

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.