Skip to main content
Click here if you are having trouble viewing this site
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Resources
Spok

ORA-01850

  1. Last updated
  2. Save as PDF

Oracle has its own built-in error codes, which can be found online or via the "oerr" command.

[amcom@amcom1 ~]$ oerr ora 1850

ORA-01850:    hour must be between 0 and 23
Cause:              An invalid hour was specified for a date using the 24-hour time format. If the 24-hour format code (HH24) is listed, the specified hour must be between 0 and 23.
Action:              Enter an hour value between 0 and 23.

This is pretty self-explanatory.  When time is defined in a 24 hour format, there's no such thing as "24 hundred hours".  The time runs from 00:00 (midnight) to 23:59 (one minute before midnight), so you can't have two different midnights.

In Smart Suite, this is sometimes seen when customers send a date in the hl7 feed with a 24:00 (hopefully not something else like 24:30!).  They must correct their date entry format.

KB31323