MSCEWI3064

In Snowflake the default calendar is Gregorian. It is not necessary to specify as a parameter.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

Snowflake default calendar system is Gregorian, so the NLS_CALENDAR=GREGORIAN parameter in the TO_DATE is not needed.

Example Code

Input Code:

SELECT TO_DATE ('1-JAN-99', 'DD-MON-YY', 'NLS_CALENDAR=GREGORIAN') from dual;

Output Code:

SELECT
/*** MSC-WARNING - MSCEWI3064 - SNOWFLAKE DEFAULT CALENDAR IS GREGORIAN. IT IS NOT NECESSARY TO SPECIFY AS A PARAMETER ***/
 TO_DATE('1-JAN-99', 'DD-MON-YY') from dual;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]