Interview Questions, Sql Server Tutorials

What is the difference between the GETUTCDATE and SYSUTCDATETIME functions?

These functions return data as UTC time (Coordinated Universal Time). In case of the GETUTCDATE(), the precision is in milliseconds. SYSUTCDATETIME() has a default precision of 7 digits after the seconds (aka nanoseconds).

SYSDATETIME( ), SYSUTCDATE( ), and SYSDATETIMEOFFSET( ) can be assigned to a variable in anyone of the date and time datatypes.

Thanks for reading this article,

Next steps :

  1. Share this with your colleagues because Sharingis Learning
  2. Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!