SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

YEARS_BETWEEN function

655578Oct 7 2008 — edited Oct 7 2008

Hi, I know this statement will get the months between my field and sysdate.

MONTHS_BETWEEN(TO_DATE(i.refund_date, 'YYYYMMDD'), sysdate)

However, I checked at google and could not find YEARS_BETWEEN function? Is there such function to get the number of years instead?

This post has been answered by Karthick2003 on Oct 7 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2008

Added on Oct 7 2008

5 comments

11,623 views