select last_day(to_date(to_char(months.month) || '/1/' || to_char(years.year), 'mm/dd/yyyy')) as range_EOM from (select rownum year from dual connect by level <= 2019) years, (select rownum month from dual connect by level <= 12) months where years.year >= 2000 and months.month >= 1
No comments:
Post a Comment