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

Last updated