SWITCHOFFSET returns a datetimeoffset with a specified timezone.
This function does not change the underlying datetime value, only the display value.
This example changes the timezone offset to +8:00 on the specified input datetimeoffset.
SELECT SWITCHOFFSET ('2022-09-28 8:54:16.1234 -5:00',
'+08:00') AS '+8:00 Offset'
| +8:00 Offset |
|---|
| 2022-09-28 21:54:16.1234000 +08:00 |
Syntax of the SWITCHOFFSET function .
SWITCHOFFSET(datetime, offset)
datetime -- a datetime or column name.
offset -- an offset expression or signed integer representing timezone offset.
