SSC-FDM-OR0047

It may be needed to set a TimeStampOutput format.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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:

IN -> Oracle_01.sql
SELECT SYSTIMESTAMP FROM DUAL;

Example of default TIMESTAMP output in Oracle

Output Code:

OUT -> Oracle_01.sql
SELECT
CURRENT_TIMESTAMP() /*** SSC-FDM-OR0047 - 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

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 [email protected]

Last updated