Описание тега ora-01861

Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading white space). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra white space.

Action: Re-enter the literal so that it matches the format string.

For example, if you tried to execute the following statement:

SELECT to_date('20041308','yyyy/mm/dd') FROM dual;

You would receive the following error message:

ORA-01861: literal does not match format string

You could correct the SQL statement as follows:

SELECT to_date('2004/08/13','yyyy/mm/dd') FROM dual;

As a general rule, if you are using the to_date, to_timestamp, to_char, and similar functions, make sure that the literal that you provide matches the format string that you've specified.