Move over GETDATE() Here Comes SYSDATETIME()

Since SQL Server 2008 and the introduction of the DateTime2 data type, neither GETDATE() nor Current_Timestamp() are the best functions to return the current date and time. Instead, SysDateTime() is preferable.
Read more here if you like.