mysql日期处理函数

过滤指定日期

---

1.近1天

select * from table where to_days(column_time) = to_days(now());

select * from table where date(column_time) = curdate();

2.近7天

select * from table where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);

3.近一个月

select * from table where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= date(column_time);

筛选出需要的日期的值

1.筛选出年月日

select DATA(column_time) from table ;

2.筛选出年月

select Extract(year_month FROM column_time) from table ;

3.筛选出年.

select Extract(year FROM column_time) from table ;

4.筛选出月

select Extract(month FROM column_time) from table ;

5.筛选出日

select Extract(day FROM column_time) from table ;

6.筛选出时分秒

select time(day FROM column_time) from table ;

比较日期

1.间隔天数

SELECT match_date,create_time FROM table_name WHERE  datediff(match_date,create_time) = 60

详见: 官方文档

---

End