Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: March 18, 2020 - 8:21 pm UTC

Last updated: March 20, 2020 - 7:00 am UTC

Version: 11

Viewed 1000+ times

You Asked

Hi,

Am getting an error like.

ORA-01843 not a valid month..

My stat like...

CASE when
To_date(column, 'mm/dd/yyyy')>= systdate then 'active '
Else 'inactive '
timezoneconverter(col)


Like

I seen Nls date format also, it is
DD mm yyyy format...that I converted to mm dd yyyy format..

But still am getting same error like not a valid month.

Can you provide rght sol. Thanks.

and Connor said...

What data type is "column"

The most common error here is that COLUMN is already a date, so when you do

to_date(column)

we silently convert the column BACK to a string, and then try to perform a TO_DATE on it.



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library