SQL GETUTCDATE Function

The SQL GETUTCDATE function is a Date and Time Function used to return the current system timestamp as a DateTime value. The return value of the GETUTCDATE function is the current UTC (Coordinated Universal Time).

It is derived from the computer’s OS (Operating System) on which the Server instance runs. The syntax of the SQL Server GETUTCDATE is

GETUTCDATE()

SQL GETUTCDATE Function Example

The GETUTCDATE function returns the datetime data type, and the format is: ‘yyyy-mm-dd hh:mm:ss.mmm’ (you can see, fractional seconds precision is 3).

SELECT GETUTCDATE() AS [Current_Date]
Get Current Date 1

Example 2

This function returns the current system timestamp. In this example, we are going to show you the GETUTCDATE function with examples. First, we selected the current date.

Next, we used the DATEPART to display the year value from today’s date & time.

In the third one, we used the DATENAME in SQL Server to display the Month name from today’s date & time.

In the last line, we used the DATEADD to display the Tomorrow date & time.

SELECT 'Today' AS 'TODAY', GETUTCDATE() AS [Curr_Date];

SELECT 'Year' AS 'YEAR', DATEPART(year, GETUTCDATE()) AS [Present_Year]; 

SELECT 'Month' AS 'MONTH', DATENAME(month, GETUTCDATE()) AS [Month_Name]; 

SELECT 'Tomorrow' AS 'DAY', DATEADD(day, 1, GETUTCDATE()) AS [NextDay];
SQL GETUTCDATE Function 2

SQL GETUTCDATE Function Example 3

In this example, we are going to find the differences in Minutes, Seconds, and Milliseconds between the Current Date & time and a variable. For this, we are using the DATEDIFF function.

DECLARE @dtime DATETIME
SET @dtime = '2016-08-27 02:54:27.530'

SELECT 'Minutes_Difference' AS 'MINUTE', DATEDIFF(MINUTE, @dtime, GETUTCDATE()) AS [Number of Minutes];

SELECT 'Seconds_Difference' AS 'SECOND', DATEDIFF(SECOND, @dtime, GETUTCDATE()) AS [Number of Seconds];

SELECT 'Millisecond_Diff' AS 'MILLISECOND', DATEDIFF(MILLISECOND, @dtime, GETUTCDATE()) AS [Number of MilliSeconds];

As you can see from the below, we used the DATEDIFF Date and Time to find the difference between the @dtime variable that we declared and the current date and time.

SQL GETUTCDATE Function 3