SQL DATE Data Type

A table with a DATE column.

CREATE TABLE DemoTable  
( 
  Id INT IDENTITY, 
  Holiday VARCHAR(100),
  HolidayDate DATE
);
GO  

INSERT INTO DemoTable VALUES ('Christmas', '2021-12-25');  
INSERT INTO DemoTable VALUES ('New Year', '12/31/2021');  
INSERT INTO DemoTable VALUES ('Valentine’s Day', '2021.02.14');
INSERT INTO DemoTable VALUES ('Halloween', '2021/10/31'); 
INSERT INTO DemoTable VALUES ('Easter', '2021-4-4'); 
GO  

SELECT * FROM DemoTable;
GO

DROP TABLE DemoTable;
GO

SELECT OrderNumber, FirstName, LastName, 
       CAST(OrderDate AS DATE) AS Date,
	   TotalAmount
  FROM [Order] O
  JOIN Customer C ON C.Id = O.CustomerId

OrderNumber	FirstName	LastName	Date	TotalAmount
542378	Paul	Henriot	2012-07-04	440.00
542379	Karin	Josephs	2012-07-05	1863.40
542380	Mario	Pontes	2012-07-08	1813.00
542381	Mary	Saveley	2012-07-08	670.80
542382	Pascale	Cartrain	2012-07-09	3730.00

CREATE TABLE DemoTable  
( 
  MyDate DATE,
  MyTime TIME,
  MySmallDateTime SMALLDATETIME,
  MyDateTime DATETIME,
  MyDateTime2 DATETIME2,
  MyDateTimeOffset DATETIMEOFFSET
);
GO  

INSERT INTO DemoTable VALUES ('2021-10-22 13:54:19:55', '2021-10-22 13:54:19:55',
                              '2021-10-22 13:54:19:55', '2021-10-22 13:54:19:55',
                              '2021-10-22 13:54:19:55', '2021-10-22 13:54:19:55');  
GO  

SELECT * FROM DemoTable;
GO

DROP TABLE DemoTable;
GO

• Our Sql TIME Data Type Reference
• Our Sql DATETIME Data Type Reference
• Our Sql Data Types Reference