MSSQL›Date/Time Functions›SWITCHOFFSET
←ISDATE

SWITCHOFFSETDate/Time Functions

COUNT→

Converts a timestamp's time zone offset.

Syntax

SWITCHOFFSET(dt_offset, tz)

Example

Enter values below to update the example in real time.

SYSDATETIMEOFFSET→
kr_time→
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '+09:00') AS kr_time;