Database Error Messages

OCI-03410

The time unit for DATEDIFF/TIMESTAMPDIFF or DATEADD is invalid.

Cause

The first argument for DATEDIFF/TIMESTAMPDIFF, or DATEADD is incorrect or not a valid time unit.


Action

Ensure that the first argument of DATEDIFF/TIMESTAMPDIFF or DATEADD is one of these keywords: YEAR, MONTH, DAY, WEEK, QUARTER, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND, or NANOSECOND. Or, ensure that the first argument is a runtime CHAR value that correctly evaluates to one of these keywords.