All errors › ORA errors
ORA-01830: Date format picture ends before converting entire input string
What it means
The input string is longer than the format mask: for example a time part in the string but not in the mask, or relying on the session NLS_DATE_FORMAT.
How to fix it
Give TO_DATE/TO_TIMESTAMP a mask that covers the whole input ('YYYY-MM-DD HH24:MI:SS'), or use DATE '2026-01-31' / TIMESTAMP literals.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.