I got ” ORA-01843: not a valid month ” error in Oracle database.
ORA-01843: not a valid month
Details of error are as follows.
ORA-01843 not a valid month Cause: A date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON. Action: Enter a valid month value in the correct format.
not a valid month
This ORA-01843 errors are related with the date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON.
TO_DATE Function
To solve this error, you should Use the “to_date” function on dates in the SQL Rule to ensure they are read successfully.
Example: to_date(’04/28/2021′, ‘MM/DD/YYYY’)
For example; If you run the following sql statement, you will get this error.
SELECT * FROM TEST_TABLE WHERE CREATED_DATE = '29/04/21';
You should use TO_DATE function as follows to solve this error.
SELECT * FROM TEST_TABLE WHERE CREATED_DATE = TO_DATE('29/04/21', 'DD/MM/YY');
You can read the following post to learn more details about TO_DATE Function.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )