Difference between Date and Datetime in SQL, datedatetime

Difference between Date and Datetime in SQL, datedatetime

Date is a new data type introduced in SQL Server 2008. It indicates a day, excluding the time part. It can represent the date range from January 1, January 1-9, December 31, 999, the first year of the year. It only requires three bytes of storage space.

DateTime date and time, which can be expressed in the range of January 1, 1753 AD 00:00:00. 000 to December 31, 9999 23:59:59. 997, accurate to 3.33 milliseconds, it requires 8 bytes of storage space.