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.

SQLServer

SWITCHOFFSET ( datetimeoffset_expression, timezoneoffset_expression )   

Snowflake SQL

SWITCHOFFSET_UDF ( timestamp_tz_expression, timezoneoffset_expression )   

Example

SQLServer

Code:

IN -> SqlServer_01.sql

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

Snowflake SQL

Code:

OUT -> SqlServer_01.sql

SELECT
  '1998-09-20 7:45:50.71345 +02:00' as fr_time,
  PUBLIC.SWITCHOFFSET_UDF('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