difference in dates

I'm an Oracle newbie...

I have two dates on table. I need to find the number of months between the two dates.

Thanks.

Hi,
You could use the built in oracle function months_between, which returns the number of months between 2 dates.

Eg:
select months_between(end_dt, start_dt)
from tbl

-Vinita

Thanks,
I tried it and got the results I was looking for.:)