Database Error Messages

OCI-03410

The time unit for DATEDIFF or TIMESTAMPDIFF is invalid.

Cause

The first argument is either missing, incorrect, or not a valid time unit.


Action

Ensure that the first argument of DATEDIFF or TIMESTAMPDIFF 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.