Oracle DB Error ORA-01836 hour conflicts with seconds in day

Oracle DB Error ORA-01836 hour conflicts with seconds in day

The following is the cause of this error:

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

Action you can take to resolve this issue: Remove the hour value from the date specification or specify the correct hour for the seconds past midnight.


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