SSC-EWI-OR0006

It may be needed to set a TimeStampOutput format.

This EWI is deprecated, please refer to SSC-FDM-OR0047 documentation.

Severity

Low

Description

TIMESTAMP_OUTPUT_FORMAT session parameter may need to be set to 'DD-MON-YY HH24.MI.SS.FF AM TZH:TZM' for timestamp output equivalence.

Example Code

Input Code:

SELECT SYSTIMESTAMP FROM DUAL;

Example of default TIMESTAMP output in Oracle

13-JAN-21 04.18.37.288656 PM +00:00

Output Code:

SELECT
CURRENT_TIMESTAMP() !!!RESOLVE EWI!!! /*** SSC-EWI-OR0006 - YOU MAY NEED TO SET TIMESTAMP OUTPUT FORMAT ('DD-MON-YY HH24.MI.SS.FF AM TZH:TZM') ***/!!!
FROM DUAL;

Example of default TIMESTAMP output in Snowflake

2021-01-13 08:18:19.720 -080

Recommendations

  • To change the timestamp output format in Snowflake use the following query:

    ALTER SESSION SET TIMESTAMP_OUTPUT_FORMAT = 'DD-MON-YY HH24.MI.SS.FF AM TZH:TZM';
  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated