关键词: 时间格式化 使用mysql提供的几种时间处理函数即可

select
 order_num,order_date
from
    Orders
where
        YEAR(order_date) = 2020
    and
        MONTH(order_date) = 1
order by 
    order_date
;