Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle SQL/PL - ORA-01843: not a valid month

User_4BTU9Dec 21 2021 — edited Dec 21 2021

I get the error message: ORA-01843: not a valid month after executing a SQL plus script. I try using the "standard" date format yyyy-mm-dd. Is SQL/PL not understanding the altered session statement?

set linesize 200
set pagesize 1000
alter session set NLS_NUMERIC_CHARACTERS = ',.';
alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd';

select
 *
from my_table
where  
date >= '2019-08-31';

exit
Comments
Post Details
Added on Dec 21 2021
1 comment
219 views