Skip to Main Content

Breadcrumb

Easter

Question and Answer

Connor McDonald

Thanks for the question.

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

Answered by: Connor McDonald - Last updated: March 20, 2020 - 7:00 am UTC

Category: PL/SQL - Version: 11

Viewed 100+ 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 we 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.



We're not taking reviews currently, so please try again later if you want to add a review.

More to Explore

PL/SQL

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