如何把每日的数据分为一个月上中下三旬,prod_date为日期字段select bc.db, bc.xb_name,r.PARENT_STATION_ID,r.PARENT_STATION_NAME,r.ORG_NAME,r.ORG_ID, r.ACCEPT_TWO_VOL,r.ACCEPT_PRESS,r.primary_id r_id from HOUR_BC_TWO bc left join PC_BSQ_MAIN_LINE_S_SHIFT r--输入输出累计流量班数据 on r.work_shifts = bc.xb_name and (r.org_id = '${org_id}' or r.org_id = '${org_id2}') and r.prod_date = to_date('${reportDate}', 'yyyy-MM-dd') order by bc.db_sort_code, bc.sort_code