What is the difference between datetime and DateTime2 in SQL Server

1. The time format for the DateTime field type is yyyy-mm-dd HH:mm:ss.fff , 3 F, which has a time precision of 1/300 seconds, which is rounded to round to. 000,. 003, or. 007-second increments when used, with an example -All: 15.007 .

2, the DateTime2 field type corresponds to the time format is yyyy-mm-dd HH:mm:ss.fffffff , 7 F, accurate to 0.1 microseconds (μs), example 12 -Geneva :19.2880929 .

3, if the date function of SQL assignment, the DateTime field type to use GETDATE() , DateTime2 field type to use sysdatetime() .

What is the difference between datetime and DateTime2 in SQL Server