Friday, 10 March 2017

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

 
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'

0 comments:

Post a Comment

Note: only a member of this blog may post a comment.