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')
;