INTERVAL YEAR TO MONTH Data Type
Last updated
Last updated
INTERVAL YEAR TO MONTH specify an interval data type to store a duration of time in years and months. ()
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 Redshift value: INTERVAL '1-2' YEAR TO MONTH
Value stored in Snowflake column: '1y, 2m'
Value as Snowflake Interval constant: INTERVAL '1y, 2m'
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.