Error:months_between for dd-mm-yy format

[tamilselvan]

How to use months_between function if dates are in dd-mm-yy
format.The function accepts only dd-mon-yy format.

SQL> select months_between('01-02-80','01-09-80')
2 from dual;
select months_between('01-02-80','01-09-80')
*
ERROR at line 1:
ORA-01843: not a valid month


This works:
1 select months_between('1-FEB-80','20-FEB-65')
2* from dual


MONTHS_BETWEEN('1-FEB-80','20-FEB-65')
--------------------------------------
179.387097

Have you ever heard of Y2K problem?

Tamil