SYSUTCDATETIME Date Function TSQL Tutorial

SYSUTCDATETIME is an date function and returns a datetime2 value (the date and time is returned as UTC time) of the computer on which the instance of SQL Server is running.

SYSUTCDATETIME Syntax:

SYSUTCDATETIME()

SYSUTCDATETIME Example:

SELECT CONVERT (date, SYSUTCDATETIME()) as Date,
CONVERT (time, SYSUTCDATETIME()) as Time,
SYSDATETIME() as SysDateTime,
SYSUTCDATETIME() as SysUtcDateTime;

DateTimeSysDateTimeSysUtcDateTime
2014-03-0114:39:21.41636202014-03-01 16:39:21.41636202014-03-01 14:39:21.4163620