Skip to Main Content

Oracle Database Discussions

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!

MONTHS_BETWEEN IN Oracle DB

Ankit Anand-OracleApr 16 2024 — edited Apr 16 2024

I was just trying to calculate months between 2 dates and found that MONTHS_BETWEEN for calculation of fractional part of the result based on a 31-day month and considers the difference in time components date1 and date2. So How to get it work when we have months not ending with 31 .

Start date :2023-12-01

End Date :2024-04-14

Comments
Post Details
Added on Apr 16 2024
8 comments
533 views