MSCEWI4070
CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
This EWI is added when the At Time Zone has the CURRENT_TIMESTAMP. This is because the result may have different results in certain cases.
Input Code:
SELECT current_timestamp at time zone 'Central America Standard Time';
Output Code:
SELECT
CONVERT_TIMEZONE('America/Costa_Rica', current_timestamp /*** MSC-WARNING - MSCEWI4070 - CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases ***/);
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated