Links

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.