SQL Error: ORA-01861: literal does not match format string 01861

By -
 
The simplest solution which worked for me is

Changing the date format for the session.

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'

You can permanently set the default nls_date_format as well:

ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY-MM-DD'

Comments

Post a Comment