Database Error Messages

ORA-01838

seconds of minute conflicts with seconds in day

Cause

A date specification contained both seconds of the minute and seconds in the day but the values did not correspond. If both types of seconds are specified, the seconds of the minute value (SS) must be the second in which the seconds past midnight value (SSSSS) fell.


Action

Remove the seconds of the minute value from the date specification or enter a value that corresponds to the given seconds in the day.