Skip to Main Content

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!

number of 1st day of the month between two dates in oracle sql

user-1uhgqSep 21 2023

I am trying to find a count of 1st day of the month between two dates in oracle sql, similar to the INTCK function in SAS. *EXAMPLE: */
/* CHRG_OFF_DT = 1/15/2023 */
/* EFF_DT = 4/27/2023 */
/* */
/* FIRST OF MONTHS: */
/* 1) 02/01/2023 */
/* 2) 03/01/2023 */
/* 3) 04/01/2023 */
/* */
/* MONTHS SINCE CHARGE OFF = 3

This post has been answered by User_3ABCE on Sep 21 2023
Jump to Answer
Comments
Post Details
Added on Sep 21 2023
2 comments
295 views