ORA-01821: date format not recognized

Posted by big on Mar 25, 2023; 5:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-01821-date-format-not-recognized-tp11743.html

Hi,
On 11.2.0.4
I have the following problem:

SQL> select count(*) from all_tables where owner='APPLSYS' and to_char (last_analyzed,'DD-MMM-YY')='01-NOV-12';

                                                                                 *
ERROR at line 1:
ORA-01821: date format not recognized

What might be the correct format for date?

'DD-MON-YY' would be I think.

Thanks and regards.