1、起初数据的样子如下:
select op.flotstocka,op.fdtmdate from mcerp_v_purchaseorder op order by op.fdtmdate
2、数据处理的统计结果如下:
select sum(op.flotstocka)total , to_CHAR(op.fdtmdate,'yyyy-mm') year_mouth from mcerp_v_purchaseorder op group by to_CHAR(op.fdtmdate,'yyyy-mm') order by to_CHAR(op.fdtmdate,'yyyy-mm')
日期差查询: select TO_DATE('2016-07-07','yyyy-mm-dd')-TO_DATE('2016-05-16','yyyy-mm-dd') as Day from dual