AT TIME ZONE
Description
Converts an inputdate to the corresponding datetimeoffset value in the target time zone. (AT TIME ZONE in Transact-SQL).
Sample Source Pattern
Syntax
Examples
IN -> SqlServer_01.sql
Result:
Code:
IN -> SqlServer_02.sql
Result:
Known Issues
Snowflake does not support all the time zones that SQL Server does. You can check the supported time zones at this link.
IN -> SqlServer_03.sql
Result:
Related EWIs
SSC-FDM-TS0024: CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases.
SSC-EWI-TS0063: Time zone not supported in Snowflake.
Last updated