How to find the Current Database UTC date and time in SQL Server?

Question

Aryan Kumar · Answer

There are two functions that you can use to find the current database UTC date and time in SQL Server:
GETUTCDATE()SYSUTCDATE()
The GETUTCDATE() function returns the current database system UTC date and time, in a 'YYYY-MM-DD hh:mm:ss. mmm' format.
The SYSUTCDATE() function also returns the current database system UTC date and time, but it has more fractional seconds precision.
For example, the following query will return the current database UTC date and time:
SQL
SELECT GETUTCDATE();
This query will return a value in the format 'YYYY-MM-DD hh:mm:ss. mmm'.
Here is the syntax for the GETUTCDATE() function:
SQL
GETUTCDATE ( )
Here is the syntax for the SYSUTCDATE() function:
SQL
SYSUTCDATE ( )
Both of these functions are very efficient, and they will not block other queries from running.

Ashutosh Kumar Verma · Answer

GETUTCDATE():
and  and  SQL GETUTCDATE() function is returns the current Database UTC (Coordinated Universal Time) date and time SQL Server.
Example:
and  and  SELECT GETUTCDATE();
Output:and  2021-11-24 05:09:12.570

interview

How to find the Current Database UTC date and time in SQL Server?

Ashutosh Kumar Verma

Can you answer this question?

2 Answers

Liked By