interview

Home / DeveloperSection / Interviews / How to find the Current Database UTC date and time in SQL Server?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.

Can you answer this question?

Answer

2 Answers

Aryan Kumar

Aryan Kumar

20-Jun-2023

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

Ashutosh Kumar Verma

23-Nov-2021

GETUTCDATE():

    SQL GETUTCDATE() function is returns the current Database UTC (Coordinated Universal Time) date and time SQL Server.

Example:

    SELECT GETUTCDATE();
Output:  2021-11-24 05:09:12.570
MindStick Training

Liked By