Skip to main content

Need Help Using Spok Knowledge?

Certain site features may not be supported by older versions of Internet Explorer.
Chrome, Edge, Firefox, or Safari will provide the most optimal experience.


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.