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;
Date | Time | SysDateTime | SysUtcDateTime |
---|---|---|---|
2014-03-01 | 14:39:21.4163620 | 2014-03-01 16:39:21.4163620 | 2014-03-01 14:39:21.4163620 |