Teradata Database Message 6974 - 17.10 - 6974 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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