Skip to main content

Need Help Using Spok Knowledge?

Internet Explorer is not supported. Please reload in Chrome, Edge, Firefox, or Safari.


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.