In this tutorial, let use learn the difference between DateTime2 Vs DateTime. Both of these data types store both date & time. DateTime is the most popular Data Type for storing the date & Time. Microsoft introduced the DateTime2 data type in SQL 2008. It also recommends not use the DateTime & SmallDateTime in new projects. Let us see the differences between them in this article
The DateTime & SmallDateTime in SQL Server are the data types that store both date & time together. The time is based on the 24 hours clock.
The DateTime2 is an SQL Server data type, that stores both date & time together. The time is based on the 24 hours clock. The DateTime2 stores the fractional seconds Up to 7 decimal places (1⁄10000000 of a second). The Precision is optional and you can specify it while defining the DateTime2 column.
The SQL Server DateTimeOffset data type stores the date & time along with the Time Zone Offset. It is similar to both DateTime & DateTime2 data types. Except that the DateTime & DateTime2 does not store the Time Zone Offset. Also DateTime is less precise than DateTime2.
Date is the SQL Server data type that we use to store Date. It stores the Date without time & without time zone information.
