mysql时间类型转换函数

给你一个按日期查询的快捷sql，你留存一下方便以后调取：
– 本日
SELECT * FROM wsd_trace WHERE TO_DAYS(CreateTime) = TO_DAYS(NOW());

– 本周
SELECT * FROM wsd_trace WHERE YEARWEEK(date_format(CreateTime, ‘%Y-%m-%d’)) = YEARWEEK(now());

– 近7天
SELECT * FROM wsd_trace WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(CreateTime);

– 本月
SELECT * FROM wsd_trace WHERE date_format(CreateTime,’%Y-%m’) = date_format(now(),’%Y-%m’)

– 查询距今6个月之前的数据
SELECT * FROM wsd_trace WHERE CreateTime between date_sub(now(),interval 6 month) and now();

– 查询本年数据
SELECT * FROM wsd_trace WHERE YEAR(CreateTime)=YEAR(NOW());

– 查询上年数据
SELECT * FROM wsd_trace WHERE year(CreateTime)=year(date_sub(now(),interval 1 year));

– 本季度
SELECT * FROM wsd_trace WHERE QUARTER(CreateTime) = QUARTER(now());