SYSDATETIMEOFFSET Date Function TSQL Tutorial

SYSDATETIMEOFFSET is an date function and returns a datetimeoffset value of the computer on which the instance of SQL Server is running.


SYSDATETIMEOFFSET Syntax:

SYSDATETIMEOFFSET()

SYSDATETIMEOFFSET Example:

SELECT CONVERT (date, SYSDATETIMEOFFSET()) as Date,
CONVERT (time, SYSDATETIMEOFFSET()) as Time,
SYSDATETIMEOFFSET() as SysDateTimeOffSet;

DateTimeSysDateTimeOffSet
2014-03-0116:25:21.19830432014-03-01 16:25:21.1983043 +02:00