Teradata Database Message 6974 - 6974 - Analytics Database - Teradata Vantage

Message

Invalid interval qualifier for the INTERVAL function. The interval qualifier must be one that is allowed for the argument's Period data type.

Explanation

The specified interval qualifier of the INTERVAL function is not allowed for the argument's Period data type. If the argument has PERIOD(DATE) data type, the interval qualifier must be YEAR, YEAR TO MONTH, MONTH, or DAY. If the argument has PERIOD(TIME(n) [WITH TIME ZONE]) data type, the interval qualifier must be HOUR, HOUR TO MINUTE, HOUR TO SECOND, MINUTE, MINUTE TO SECOND or SECOND. If the argument has PERIOD(TIMESTAMP(n) [WITH TIME ZONE]) data type, any interval qualifier is allowed.

Generated By

Parser.

For Whom

End User.

Notes

None

Remedy

Correct the argument and resubmit