MSC-PG0019

The use of Invertal within a to_char function is not compatible with Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

High

Description

The use of interval within the to_char to convert date/times data types into text is not supported in Snowflake.

Code Example

Input Code:

PostgreSQL

SELECT to_char(interval '15h 2m 12s', 'HH24:MI:SS');

Output Code:

Snowflake

SELECT
-- ** MSC-ERROR - MSC-PG0019 - CONVERTS INTERVAL TO STRING ACCORDING TO THE GIVEN FORMAT IS NOT SUPPORTED. **
--       to_char(interval '15h 2m 12s', 'HH24:MI:SS')
                                                   ;

For more information please refer to

• PostgreSQL to_char.

• SnowFlake to_char.

Recommendations

• If you need more support, you can email us at [email protected]