6974 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.
Remedy:
Correct the argument and resubmit