SQL & PL/SQL

Hello All,

I want to list all members who are turning to 65 (age in years).

for this I used numtoyminterval(months_between(trunc(sysdate),DATE_OF_BIRTH),'month') function and arguments.

Example of values returned are : +13-00, +64-9, +65-04 etc.

Now I want to list all members whose DOB is greater than 64 years and 6 months , but not greater than +65-00.

Now I observed that =, >,< , like kind of operators are not allowed with interval Year to month data type.

One workaround is-

MONTHS_BETWEEN(TRUNC(SYSDATE),DATE_OF_BIRTH) BETWEEN 774 AND 780

However any idea if I can manage operator on year to moth interval? or any other suggestions?

Thanks,

Rajneesh