Today, I’d like to write about a tiny little issue – which can cause some real trouble in Oracle 19c. This blog post is about the Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8.
My testcase is super-simple – and you can reproduce it even without any object in 2 seconds (one for “copy“, the other for “paste“). Simply execute this query:
select to_date('20191120','RRMMDD') from dual;
Or this one where I replace “RR” with the more common “YY”:
select to_date('20191120','YYMMDD') from dual;… Continue reading...