Skip to Main Content
Forums

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!

Query to count days between two dates according to the month is 30 days only

Ashraf AbdelhaliemSep 10 2018 — edited Sep 30 2018

Hi

In case i need the diff days between two dates like 16/10/2018 and 06/12/2018 here the result should be days which are considering the months is 30 days not more or less .

More one Example if there are 01/11/2018 and 01/10/2018 here the diff should be 30 days , and if  13/11/2018 and 01/10/2018 the diff has to consider month as 30 days .

Thanks

This post has been answered by Ashraf Abdelhaliem on Sep 27 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2018
Added on Sep 10 2018
38 comments
10,650 views