select * from V_SCM_STOREINOUT_ACCOUNT t where to_char(t.store_date,'yyyy-mm') like '2017-08';
注意这里的mm对应08而不是8
select * from V_SCM_STOREINOUT_ACCOUNT t where to_char(t.store_date,'yyyy-mm') like '2017-08';
注意这里的mm对应08而不是8
转载于:https://www.cnblogs.com/zhuxueyuan/p/7363107.html