Am getting an error like.
ORA-01843 not a valid month..
My stat like...
To_date(column, 'mm/dd/yyyy')>= systdate then 'active '
Else 'inactive '
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"
We're not taking reviews currently, so please try again later if you want to add a review.
The most common error here is that COLUMN is already a date, so when you do
we silently convert the column BACK to a string, and then try to perform a TO_DATE on it.