AT TIME ZONE

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• SQL Server

• Azure Synapse Analytics

Description

Converts an inputdate to the corresponding datetimeoffset value in the target time zone. (AT TIME ZONE in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

inputdate AT TIME ZONE timezone

Snowflake SQL

Examples

SQL Server

IN -> SqlServer_01.sql

SELECT CAST('2022-11-24 11:00:45.2000000 +00:00' as datetimeoffset) at time zone 'Alaskan Standard Time';

Result:

                          DATE|
------------------------------+
2022-11-24 02:00:45.200 -09:00|

Snowflake SQL

SQL Server

Code:

IN -> SqlServer_02.sql

SELECT current_timestamp at time zone 'Central America Standard Time';

Result:

                          DATE|
------------------------------+
2022-10-10 10:55:50.090 -06:00|

Snowflake SQL

Known Issues

1. Snowflake does not support all the time zones that SQL Server does. You can check the supported time zones at this link.

SQL Server

IN -> SqlServer_03.sql

SELECT current_timestamp at time zone 'Turks And Caicos Standard Time';

Result:

                          DATE|
------------------------------+
2022-12-14 20:04:18.317 -05:00| 

Snowflake SQL

Related EWIs

1. SSC-FDM-TS0024: CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases.

2. SSC-EWI-TS0063: Time zone not supported in Snowflake.