CODE EXAMPLE FOR SQL

convert date to datetime sql

-- 2 ways 
SELECT CONVERT(datetime, '2021-01-01');
SELECT CAST('2021-01-01' AS datetime);