SSC-EWI-TS0070
CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases.
Last updated
CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases.
Last updated
This EWI is added when the At Time Zone has the CURRENT_TIMESTAMP. This is because the result may have different results in some instances.
The main difference is that in SQL Server, CURRENT_TIMESTAMP returns the current system date and time in the server time zone and in Snowflake CURRENT_TIMESTAMP returns the current date and time in the UTC (Coordinated Universal Time) time zone.
This is an example if you want to keep the same format in Snowflake.
In Snowflake you can use to change the default time zone. For example:
If you need more support, you can email us at