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