九阴真经


日期

<h5>日期格式化</h5> <pre><code>#N小时前 5小时前 SELECT count(0) from yd_big_frame_log WHERE create_time &gt; 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) &lt;=7; SELECT * from user where DATE_FORMAT(create_time,"%Y-%m-%d") &lt; 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>

页面列表

ITEM_HTML