Home >Database >Mysql Tutorial >mysql查询一天一周一个月的数据_MySQL
mysql查询一天一周一个月的数据_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:35:131177browse
bitsCN.com
mysql查询一天一周一个月的数据
查询一天：
Java代码
select * from table where to_days(column_time) = to_days(now());
select * from table where date(column_time) = curdate();
查询一周：
Java代码
select * from table where DATE_SUB(CURDATE(), INTERVAL 7 DAY)
查询一个月：
Java代码
select * from table where DATE_SUB(CURDATE(), INTERVAL 1 MONTH) bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：数据库设计1_MySQLNext article：MySQL数据库连接JDBC_MySQL