Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Spok

ORA-01850

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