以t_order_list表为例:
SELECT * FROM t_order_list t
where
MONTH(t.Factory_Order_Date)=MONTH(NOW())
and year(t.Factory_Order_Date)=year(now());
以t_order_list表为例:
SELECT * FROM t_order_list t
where
MONTH(t.Factory_Order_Date)=MONTH(NOW())
and year(t.Factory_Order_Date)=year(now());