whth dataSpan as( select to_char(date'2023-02-01'+level -1,'yyyy-mm-dd')data_date from dual connect by level <=date'2023-02-28' - date'2023-02-16'+1 )
LAST_DAY(sysdate)
LAST_DAY(NOW()) 就能获取本月最后一天的日期