SELECT MONTHS_BETWEEN( TO_DATE(SUBSTR(edt, 1, 6), 'yyyymm')
                     , TO_DATE(SUBSTR(sdt, 1, 6), 'yyyymm')
                     ) + 1 mm
  FROM (SELECT '20160428' sdt, '20160501' edt FROM dual)
;