Oracle DB Error ORA-01838 seconds of minute conflicts with seconds in day

Oracle DB Error ORA-01838 seconds of minute conflicts with seconds in day

The following is the cause of this error:

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) will fall.

Action you can take to resolve this issue: Remove the seconds of the minute value from the date specification or enter a value that corresponds to the given seconds in the day.


Tags: Database, Microsoft, SQL, Oracle, Software, DBMS




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution