Hi All,
I would like your help in fixing ORA-01843: not a valid month.
When I use the below code
select count(*) from
TABLE
where (round(SYSDATE - to_date(LAST_UPDATE_DATE,'DD-MM-YYYY:hh24:mi:ss'),2)) > 2.1;
I am getting error ORA-01843: not a valid month
whereas when I use
select (round(SYSDATE - to_date(LAST_UPDATE_DATE,'DD-MM-YYYY:hh24:mi:ss'),2)) from
TABLE
where (round(SYSDATE - to_date(LAST_UPDATE_DATE,'DD-MM-YYYY:hh24:mi:ss'),2)) > 2.1
I am able to get records like
112.13
90.07
70.24
70.03
70.02
Why am I getting ORA-01843: not a valid month ? How do I fix it?
Any help on this would be of immense help.
Regards,
Saumyadip.