Comment on page

MSCEWI4070

CURRENT_TIMESTAMP in At Time Zone statement may have a different behavior in certain cases.

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]​

MSCEWI4069

MSCEWI4071

Last modified 22d ago