Database Error Messages

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

ORA-01836

hour conflicts with seconds in day

Cause

The wrong hour was specified with seconds in the day. If an hour was specified with seconds past midnight (SSSSS), it must be the hour in which the seconds value fell.


Action

Remove the hour value from the date specification or specify the correct hour for the seconds past midnight.