INTERVAL DAY TO SECOND Data Type
Description
INTERVAL DAY TO SECOND stores a period of time in terms of days, hours, minutes, and seconds. (Oracle SQL Language Reference INTERVAL DAY TO SECOND Data Type)
There is no equivalent for this data type in Snowflake, it is currently transformed to VARCHAR
.
Sample Source Patterns
Interval Day to Second in Create Table
Oracle
Snowflake
The Interval value is transformed to a supported Snowflake format and then inserted as text inside the column. Since Snowflake does not support Interval as a data type, it is only supported in arithmetic operations. In order to use the value, it needs to be extracted and used as an Interval constant (if possible).
Original Oracle value: INTERVAL '1 2:3:4.567' DAY TO SECOND
Value stored in Snowflake column: '1d, 2h, 3m, 4s, 567ms'
Value as Snowflake Interval constant: INTERVAL '1d, 2h, 3m, 4s, 567ms'
Retrieving data from an Interval Day to Second column
Oracle
Snowflake
Known Issues
1. Only arithmetic operations are supported
Snowflake Intervals have several limitations. Only arithmetic operations between DATE
or TIMESTAMP
and Interval Constants are supported, every other scenario is not supported.
Related EWIs
SSC-EWI-0036: Data type converted to another data type.
Last updated