T-SQL SYSUTCDATETIME() Function

The T-SQL (Transact-SQL) SYSUTCDATETIME() function returns the current date and time as UTC time (Coordinated Universal Time). This function derives this value from the operating system of the computer on which the instance of SQL Server runs.

The SYSUTCDATETIME() function returns the system date and time in the format 'yyyy-mm-dd hh:mi:ss.mmmmmmm'.

Syntax

SYSUTCDATETIME()

Parameters

No parameter is required.

Return Value

Returns the current date and time.

Example 1:

The example below shows the usage of SYSUTCDATETIME() function.

SELECT SYSUTCDATETIME();
Result: '2021-12-27 05:11:57.1234567'

Example 2:

Consider a database table called EmployeeLogin with the following records:

To insert a new record in this table, the following statement can be used.

INSERT INTO EmployeeLogin 
VALUES (6, 'Suresh', SYSUTCDATETIME());

-- see the result
SELECT * FROM EmployeeLogin;

This will produce a result similar to: