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
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.

MSCEWI1007

MSCEWI1009

Last modified 1yr ago