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.
SELECT CONVERT (date, SYSUTCDATETIME()) as Date,
CONVERT (time, SYSUTCDATETIME()) as Time,
SYSDATETIME() as SysDateTime,
SYSUTCDATETIME() as SysUtcDateTime;
|2014-03-01||14:39:21.4163620||2014-03-01 16:39:21.4163620||2014-03-01 14:39:21.4163620|