SWITCHOFFSET#
Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset.
Syntax#
SWITCHOFFSET ( datetimeoffset_expression, timezoneoffset_expression )
Arguments#
datetimeoffset_expression
Is an expression that can be resolved to a datetimeoffset(n) value.
timezoneoffset_expression
Is a string in the format [+|-]TZH:TZM, or a signed integer (of minutes), that represents the time zone offset.
Return types#
datetimeoffset with the fractional seconds precision of datetimeoffset_expression.
Example#
SELECT SWITCHOFFSET(CAST('2026-07-13 12:00:00 +00:00' AS datetimeoffset(0)), '+02:00');
-- Result: 2026-07-13 14:00:00 +02:00