// Oracle error reference
ORA-01830: date format picture ends before end of input
The string being converted to a date has more characters than the format model describes, typically a time part the format leaves out.
- Error code
ORA-01830- Category
- Data values and conversion
What it means
ORA-01830 means Oracle finished applying the format model while there was still input left, for example converting '2026-11-09 14:30:00' with 'YYYY-MM-DD'.
Common causes
- A timestamp string converted with a date-only format.
- Implicit conversion of a string with a time part, using an
NLS_DATE_FORMATwithout one. - Fractional seconds passed to
TO_DATE, which doesn't support them.
How to fix it
-
Include every part of the string in the format.
SELECT TO_DATE('2026-11-09 14:30:00', 'YYYY-MM-DD HH24:MI:SS') FROM dual; -
Use
TO_TIMESTAMPfor fractional seconds.SELECT TO_TIMESTAMP('2026-11-09 14:30:00.123', 'YYYY-MM-DD HH24:MI:SS.FF3') FROM dual;
Related errors
More data values and conversion errors
ORA-12899value too large for columnORA-01401inserted value too large for columnORA-01438value larger than specified precisionORA-01722invalid numberORA-00932inconsistent datatypesORA-01476divisor is equal to zero
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
// fewer errors, faster fixes
Work on Oracle in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.