Oracle Forms

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!

SQL to display start, end date, days in each month between 2 dates

DragonKingJul 27 2013 — edited Jul 30 2013

HI all,

Please hep since I'm so new on this. I have a date range 01/15/2012 to 11/26/2012. What I have to do is to display it like below:

01/15/2012, 01/31/2012, 16 days

02/01/2012, 02/29/2012, 29 days

03/01/2012, 03/31/2012, 31 days

11/01/2012, 11/26/2012, 26 days.

Thanks for helping me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2013

Added on Jul 27 2013

#forms, #moved-from-devops

4 comments

533 views