select convert(varchar(16),时间,120),count(*) from tb group by convert(varchar(16)这是MSSQL的语法,你自己查查MYSQL里convert函数是不是这样表示的.
MSSQL的:select CONVERT(varchar(16),时间列,120),sum(数据量) as 数据量 from tb group by CONVERT(varchar(16),时间列,120)
select CONVERT(varchar(16),时间列,120),sum(数据量) as 数据量 from tb where 时间 between '2011-11-28 8:00' and '2011-11-29 8:00' group by CONVERT(varchar(16),时间列,120)
MYSQL中应该用DATE_FORMAT(date,format)来做 不写了
MYSQL: select convert(时间,char(16)),count(*) from tb group by convert(时间,char(16))
group by convert(varchar(16)这是MSSQL的语法,你自己查查MYSQL里convert函数是不是这样表示的.
CONVERT(varchar(16),时间列,120),sum(数据量) as 数据量
from
tb
where
时间
between
'2011-11-28 8:00' and '2011-11-29 8:00'
group by
CONVERT(varchar(16),时间列,120)
select convert(时间,char(16)),count(*) from tb
group by convert(时间,char(16))