DATETIME vs DATETIME2 in SQL Server
Click here to Subscribe to IT PORT Channel : / @itport28
Datetime vs Datetime2. Major difference is based on nano seconds fractional precision. These fractional precision 7 digits in datetime2 and 3 digits for datetime. user can defined the size of fractional precision in datetime2. Datetime range starts from 01-Jan-1753 and Datetime2 starts from 01-jan-0001.