I came across the article written by Pinal Dave about the difference between DATETIME and DATETIME2. In my years working as a database administrator, I did use DATETIME most of the time for database structure design. So far, I did not use the data type DATETIME2 before.
It becomes more interesting when he shared with us the problems when using DATETIME2 and SYSDATETIME(). In a short summary he commented as below:-
The best way is to use GETDATE() if you are using DATETIME, and SYSDATETIME() if you are using DATETIME2 to populate them with current date and time for accurately addressing the precision. As DATETIME2 is introduced in SQL Server 2008, the above script will only work with SQL Server 2008 and later versions.
Read Pinal Dave full article, https://blog.sqlauthority.com/2010/06/11/sql-server-difference-between-datetime-and-datetime2/
LiYenzWordPress 