INTERVAL DAY TO SECOND Data Type
Last updated
Last updated
INTERVAL DAY TO SECOND specify an interval literal to define a duration in days, hours, minutes, and seconds. ()
There is no equivalent for this data type in Snowflake, it is currently transformed to VARCHAR
.
The use of the Interval data type is planned for implementation in future updates.
Original Oracle value: INTERVAL '1 2:3:4.567' DAY TO SECOND
Value stored in Snowflake column: '1days, 2hours, 3mins, 4secs, 56ms'
Value as Snowflake Interval constant: INTERVAL '1days, 2hours, 3mins, 4secs, 56ms'
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 (if possible).
Snowflake Intervals have several limitations. Only arithmetic operations between DATE
or TIMESTAMP
and are supported, every other scenario is not supported.
: Data type converted to another data type.