If you need a more fractional seconds precision, use the SYSUTCDATETIME instead of GETUTCDATE()
Let's see the results when running some common date and time functions in SQL Server:
As you can observe, the SYSDATETIME and SYSUTCDATETIME are used to display time with fractional second precision. The SYSDATETIMEOFFSET displays the time zone offset.
To find a difference between the Local time and UTC time use this query:
Note: You may also want to checkout the SYSUTCDATETIME SWITCHOFFSET and TODATETIMEOFFSET functions
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|