MSCEWI3006
It may be needed to set a TimeStampOutput format.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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:
-- Given the column
COL1 TIMESTAMP DEFAULT SYSTIMESTAMP
Example of default TIMESTAMP output in Oracle
13-JAN-21 04.18.37.288656 PM +00:00
Output Code:
COL1 TIMESTAMP DEFAULT CURRENT_TIMESTAMP /**** WARNING: You may need to set TimeStampOutput format ('DD-MON-YY HH24.MI.SS.FF AM TZH:TZM') ****/
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 [email protected]
Last updated