year,month 写法

select *

from

Orders

where

year(order_date)=2020

and

month(order_date)=01

order by

order_date

#date_format写法 select order_num,order_date from Orders where date_format(order_date,'%Y-%m')='2020-01' order by order_date