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