TIMESTAMP Data Type
Description
The TIMESTAMP data type is an extension of the DATE data type. It stores the year, month, and day of the DATE data type, plus hour, minute, and second values. (Oracle SQL Language Reference Timestamp Data Type)
Both Oracle and Snowflake TIMESTAMP
data types have the same precision range (0-9) but different default values. In Oracle, the default precision value is 6 and in Snowflake is 9.
However, there is a difference in behavior when an inserted value exceeds the set precision. Oracle rounds up the exceeding decimals, while Snowflake just trims the values.
Sample Source Patterns
Timestamp in Create Table
Oracle
IN -> Oracle_01.sql
Snowflake
OUT -> Oracle_01.sql
Retrieving data from a Timestamp column
Oracle
IN -> Oracle_02.sql
Snowflake
OUT -> Oracle_02.sql
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated