Difference b/w GETDATE And SYSDATETIME Function In SQL Server

In SQL Sever, when we need to get the system date time, then generally, we use GETDATE() and SYSDATETIME() to get the system date time. Most of the developers use these functions but aren't aware of the the difference b/w these two. In this blog, we will learn about the difference b/w both the functions.

GETDATE()

 

SYSDATETIME()
 
 

After examining both functions, we see that there is a difference in fractional second part of result.  GETDATE function doesn't return the system time zone offset but SYSDATETIME() returns the system time zone offset.