知识点
时间、日期的查询方法
Orders订单表
【问题】编写 SQL 语句，返回 年 1 月的所有订单的订单号（order_num）和订单日期（order_date），并按订单日期升序排序
--用like来查找select order_num, order_datefrom Orderswhere order_date like '-01%'order by order_date--切割字符串select order_num, order_datefrom Orderswhere left(order_date, 7) = '-01'order by order_date--字符串比较select *from Orderswhere order_date >= '-01-01 00:00:00' and order_date <= '-01-31 23:59:59'order by order_date;--用正则来查找（效率不如like，能用like就用like）select order_num, order_datefrom Orderswhere order_date regexp '-01'order by order_date--时间函数匹配select order_num, order_datefrom Orderswhere year(order_date) = '' and month(order_date) = '1'order by order_date--利用date_format函数 （参考其中的匹配规则进行匹配）select order_num, order_datefrom Orderswhere date_format(order_date, '%Y-%m')='-01'order by order_date
【示例结果】
返回订单号order_num，和order_date订单时间
