MSCEWI4060
Datetime interval not supported by Snowflake.
Medium
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:
- millisecond
- ms
- microsecond
- mcs
- tzoffset
- tz
SELECT
DATEPART(millisecond, getdate()),
DATEADD(tz, getdate(), 0);
1
SELECT
2
-- ** MSC-ERROR - MSCEWI4060 - THE DATETIME INTERVAL 'millisecond' IS NOT SUPPORTED BY SNOWFLAKE **
3
--DATEPART(millisecond, CURRENT_TIMESTAMP() :: TIMESTAMP)
4
,
5
-- ** MSC-ERROR - MSCEWI4060 - THE DATETIME INTERVAL 'tz' IS NOT SUPPORTED BY SNOWFLAKE **
6
--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.
Last modified 4mo ago