Search notes:

ORA-01861: literal does not match format string

The ORA-01861: Literal does not match format string usually occurs with the to_XXX conversion functions (to_char, to_date, to_number).

alter session set nls_date_format = 'dd.mm.yyyy';

select
   to_date('1970-08-28')
from
   dual;

See also