select * from h_v_Sc_MouldProdInHouseBillList where 库存组织='手机事业部' and CONVERT(varchar(100),日期, 23) >= '2021-03-05' and CONVERT(varchar(100),日期, 23) <= '2022-04-11' and CONVERT(varchar(100),日期, 23) >= '2021-03-05' and CONVERT(varchar(100),日期, 23) <= '2022-04-11'order by hmainid desc
|