The difference between datetime and DateTime2 in SQL Server

The time format for the DateTime field type is Yyyy-mm-dd hh:mm:ss.fff,3 F, which is accurate to 1 milliseconds (ms), example 2014-12-0317:06:15.433.

The DateTime2 field type corresponds to a time format of Yyyy-mm-dd hh:mm:ss.fffffff,7 F, which is accurate to 0.1 microseconds (μs), example 2014-12-0317:23:19.2880929.

If the date function of SQL is assigned, the DateTime field type is GETDATE () and the DateTime2 field type is Sysdatetime ().

The difference between datetime and DateTime2 in SQL Server