Datetime interval not supported by Snowflake.
This is EWI is added to a function where one of the following datetime intervals, which are not supported by Snowflake, are found as a function parameter:
DATEADD(tz, getdate(), 0);
-- ** MSC-ERROR - MSCEWI4060 - THE DATETIME INTERVAL 'millisecond' IS NOT SUPPORTED BY SNOWFLAKE **
--DATEPART(millisecond, CURRENT_TIMESTAMP() :: TIMESTAMP)
-- ** MSC-ERROR - MSCEWI4060 - THE DATETIME INTERVAL 'tz' IS NOT SUPPORTED BY SNOWFLAKE **
--DATEADD(tz, CURRENT_TIMESTAMP() :: TIMESTAMP, 0)
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.