sql 语句中的时间查询总结

 在web项目中，经常会用到时间查询，现将常用的几个时间查询语句总结如下

 

全部的日志
select * from Logs order by id desc

 

今天的日志
select * from Logs where year(date)=year(now()) and month(date)=month(now()) and day(date)=day(now()) order by id desc

昨天的日志
select * from Logs where year(date)=year(now()) and month(date)=month(now()) and day(date)=day(now())-1 order by id desc

本周的日志
select * from Logs where year(date)=year(now()) and week(date,1)=week(now(),1) order by id descgs order by date desc";

上周的日志
select * from Logs where year(date)=year(now()) and week(date,1)=week(now(),1)-1 order by id desc

本月的日志
select * from Logs where year(date)=year(now()) and month(date)=month(now()) order by id desc";

上个月日志
select * from Logs where year(date)=year(now()) and month(date)=month(now())-1 order by id desc