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