题解 | #返回 2020 年 1 月的所有订单的订单号和订单日期#

select order_num,order_date from Orders where date_format(order_date,'%Y-%m')='2020-01'  order by order_date;
/*利用date_format，格式化数据*/
select *from Orders where year(order_date)=2020 and month(order_date)=01 order by order_date;
/*利用year,month 函数*/