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!

To find months and days between 2 dates

SureshMOct 9 2013 — edited Oct 11 2013

Hi,

I want to find the months and days between 2 dates.

For Eg.

Date-1 : 25-Aug-2013

Date-2 : 23-Oct-2013

If we consider every month as 30 days it should give

25-Aug-2013 to 30-Aug-2013 = 6 days

01-Sep-2013 to 30-Sep-2013 = 1 Month

23-Oct-2013 to 30-Oct-2013 = 8 days

Total = 1 month and 14 days.

Kindly help at the earliest.

Thanks & Regards

Suresh

This post has been answered by davidp 2 on Oct 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2013

Added on Oct 9 2013

33 comments

18,029 views