Search notes:

ORA-01840: input value not long enough for date format

select
   to_date('2022-07', 'yyyy-mm-dd')
from
   dual;

See also

The date datatype
ORA-01830: date format picture ends before converting entire input string
Other Oracle error messages

Index