Default format: YYYY-MM-DD
Range: 0001-01-01 through 9999-12-31
Example
DECLARE @date1 date
CREATE TABLE Table1 ( datefield date )
-- difference between date and datetime
DECLARE @date date= '12-10-21';
DECLARE @datetime datetime= @date;
SELECT @date AS 'date', @datetime AS 'datetime';
--Result
--date datetime
------------ -----------------------
--2021-12-10 2021-12-10 00:00:00.000
Other Examples
