T-SQL Tutorial

T-SQL SysUtcDateTime function


The T-SQL 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