返回指定日期的数据-sql

返回指定日期的数据-牛客

思路

1. like匹配
2. 时间函数：year()、month()、day()
3. 时间格式函数：date_format()
4. 切割函数：left()

# 1、用like
# select order_num, order_date from Orders
# where order_date like '2020-01%'
# order by order_date;
#2、用时间函数
# select order_num, order_date 
# from Orders
# where year(order_date) = '2020' and month(order_date) = '1'
# order by order_date;
# 3、用date_format函数
# select order_num, order_date 
# from Orders
# where date_format(order_date,'%Y-%m')='2020-01'
# order by order_date;
#4、切割字符串
select order_num, order_date 
from Orders
where left(order_date,7)='2020-01'
order by order_date;