The difference between Date and datetime in SQL

Date is the newly introduced data type for SQL Server 2008. It represents a day, and does not contain a time part, which can be expressed from January 1 to December 31, 9999 of the year of the A.D.. Only 3 bytes of storage space is required.

The datetime date and Time section, which can represent a date range from January 1, 1753 A.D. 00:00:00.000 to December 31, 9999 23:59:59.997, is accurate to 3.33 milliseconds, which requires 8 bytes of storage space.

The difference between Date and datetime in SQL