The conversion of a date data type to a datetime data type resulted in an out-of-range value

Solution 1:

It worked like this for me

ALTER TABLE NAME_TABLE ALTER COLUMN NAME_COLUMN  datetime2 not null