Links

MSCEWI1008

Expression at time zone changed, the result may be different.

Severity

Low

Description

This warning appears when a specific timestamp expression from the source code is changed to a specific time function in the converted code. Also indicates the result may be different.

Example Code

Input Code:

SELECT TIMESTAMP '1998-12-25 09:26:50.12' AT LOCAL FROM DUAL;

Output Code:

SELECT
/*** MSC-WARNING - MSCEWI1008 - EXPRESSION AT TIME ZONE CHANGED, RESULT MAY BE DIFFERENT ***/
TO_TIMESTAMP_LTZ( TIMESTAMP '1998-12-25 09:26:50.12')
FROM DUAL;

Recommendation