SWITCHOFFSET
Description
The SWITCHOFFSET adjusts a given timestamp value to a specific timezone offset. This is done through numerical values. More information can be found at SWITCHOFFSET (Transact-SQL).
Sample Source Pattern
Syntax
A UDF Helper accomplish functional equivalence, also it shares the same syntax as the SQLServer's SWITCHOFFSET function.
SWITCHOFFSET ( datetimeoffset_expression, timezoneoffset_expression )
Example
Code:
SELECT
'1998-09-20 7:45:50.71345 +02:00' as fr_time,
SWITCHOFFSET('1998-09-20 7:45:50.71345 +02:00', '-06:00') as cr_time;
Result:
fr_time cr_time
------------------------------- ----------------------------------
1998-09-20 7:45:50.71345 +02:00 1998-09-19 23:45:50.7134500 -06:00
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated