日期
<h5>日期格式化</h5>
<pre><code>#N小时前 5小时前
SELECT count(0) from yd_big_frame_log WHERE create_time > DATE_ADD(NOW(),INTERVAL-5 HOUR);
#今天
SELECT * from user where TO_DAYS(NOW()) = TO_DAYS(create_time);
#昨天
SELECT * from user where TO_DAYS(CURDATE()) -TO_DAYS(create_time) =1;
#一周前
SELECT * from user where TO_DAYS(CURDATE()) -TO_DAYS(create_time) <=7;
SELECT * from user where DATE_FORMAT(create_time,"%Y-%m-%d") < NOW();
#格式化日期
SELECT DATE_FORMAT(create_time,"%Y%m%d") from user ORDER BY create_time desc;
SELECT DATE_FORMAT(create_time,"%Y-%m-%d") from user;
#M D 表示英文
SELECT DATE_FORMAT(create_time,"%Y-%M-%D") from user;
#查询当月数据
SELECT * from user where MONTH(create_time) =MONTH(NOW());
#查询本季度数据
SELECT * from user where QUARTER(create_time) = QUARTER(NOW());
#查询当年数据
SELECT * from user where YEAR(create_time) = YEAR(NOW());</code></pre>