sql

来源：互联网发布：网警网络监控软件v2.0 编辑：程序博客网时间：2024/06/14 12:11

-- 查7天的不包含今天
select *from dgys_parkingsum where time < DATE_ADD(NOW(),INTERVAL -1 DAY)
and time > DATE_ADD(NOW(),INTERVAL -8 DAY)

-- 查7天的不包含今天
select * from dgys_parkingsum
where DATE_FORMAT(time,'%Y-%M-%D') <= DATE_FORMAT(DATE_ADD(NOW(),INTERVAL -1 DAY),'%Y-%M-%D')
and DATE_FORMAT(time,'%Y-%M-%D') > DATE_FORMAT(DATE_ADD(NOW(),INTERVAL -8 DAY),'%Y-%M-%D')

GROUP BY DATE_FORMAT(time,'%Y-%M-%D')

-- 查7天的包含今天

SELECT * from dgys_parkingsum WHERE time > (SELECT DATE_ADD(MAX(time),INTERVAL -7 DAY) FROM dgys_parkingsum)
ORDER BY time DESC;

-- 查7天的不包含今天
select *from dgys_parkingsum where datediff(now(),time)<=6
group by day(time);

-- 按时间段查看

select
ecologicalindex,datacreationtime,comfortableindex,COairindex,
O3airindex,NO2airindex,SO2airindex,PM10airindex,PM25airindex
from
dgys_environment_indexsum
where
flag=2
and DATE_FORMAT(datacreationtime,'%Y-%m-%d')
between DATE_FORMAT(#{0},'%Y-%m-%d') and
DATE_FORMAT(#{1},'%Y-%m-%d')

阅读全文

0 0