Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-01898

too many precision specifiers in date format model

Cause

While trying to truncate or round dates, too many format models (like 'YY' or 'MM') for ROUND or TRUNC were found in the call. Not all date format models can be combined in a call to TRUNC and ROUND.


Action

Check the documentation for which date format models can be combined in the call to ROUND and TRUNC. Correct the date format and retry the operation.