SQL SYSDATETIMEOFFSET() is an inbuilt function that returns a value that represents the current system date and time, which also includes the time zone, of the computer on which the SQL Server instance is running. The datatype returned is of DATETIMEOFFSET (7) type.

SQL SYSDATETIMEOFFSET()

SQL SYSDATETIMEOFFSET() returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is included.

Syntax

SELECT SYSDATETIMEOFFSET();

#sql #sql sysdatetimeoffset() #sql server