MSC-PG0010

Precision format is not supported in Snowflake.

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

Severity

Medium

Description

This error is added when Snowflake does not support the precision format in the date_trunc function.

Code Example

Input Code:

PostgreSQL

SELECT 
   DATE_TRUNC('decade', TIMESTAMP '2017-03-17 02:09:30'),
   DATE_TRUNC('century', TIMESTAMP '2017-03-17 02:09:30'),
   DATE_TRUNC('millennium', TIMESTAMP '2017-03-17 02:09:30');

Output Code:

Snowflake

SELECT
-- ** MSC-ERROR - MSC-PG0010 - DECADE FORMAT IS NOT SUPPORTED IN SNOWFLAKE. **
--   DATE_TRUNC('decade', TIMESTAMP '2017-03-17 02:09:30')
                                                        ,
-- ** MSC-ERROR - MSC-PG0010 - CENTURY FORMAT IS NOT SUPPORTED IN SNOWFLAKE. **
--   DATE_TRUNC('century', TIMESTAMP '2017-03-17 02:09:30')
                                                         ,
-- ** MSC-ERROR - MSC-PG0010 - MILLENNIUM FORMAT IS NOT SUPPORTED IN SNOWFLAKE. **
--   DATE_TRUNC('millennium', TIMESTAMP '2017-03-17 02:09:30')
;

Recommendations

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