SYSDATETIMEOFFSET ( )

TIMESTAMP WITH TIME ZONE

• TIMESTAMP WITH TIME ZONE data type
• SWITCHOFFSET function [Date and time]

The following example returns the current date and time and the time zone offset of the database server.

SELECT SYSDATETIMEOFFSET ( );

The following example converts the SYSDATETIMEOFFSET value to the time zone of the client computer.

SELECT SWITCHOFFSET ( SYSDATETIMEOFFSET ( ),
CAST( connection_property ('TimeZoneAdjustment') AS INT ));