select to_char(l.starttime, 'hh'),count(*) from CPAS_LOG.TABLOG_GS l where to_char(l.starttime, 'yyyy-mm-dd') = '2012-11-19' group by to_char(l.starttime, 'hh')
SELECT COUNT(*) FROM CPAS_LOG.TABLOG_GS WHERE to_char(starttime,'yyyy-mm-dd') = '&date' GROUP BY to_char(starttime, 'hh24');
If database is oracle: SELECT to_char(starttime, 'yyyy-mm-dd hh24') hour,count(1) every_hour_count FROM CPAS_LOG.TABLOG_GS GROUP BY to_char(starttime, 'yyyy-mm-dd hh24');
如果没有的话,就很难办了
from CPAS_LOG.TABLOG_GS l
where to_char(l.starttime, 'yyyy-mm-dd') = '2012-11-19'
group by to_char(l.starttime, 'hh')
想看每小时的数据量 就要按照小时进行group by ,然后count(*)
to_char(l.starttime, 'hh')代表把时间转换成小时
to_char你知道怎么用吧 不会的话可以百度
‘yyyy-mm-dd hh24:mi:ss’年月日时分秒
SELECT COUNT(*)
FROM CPAS_LOG.TABLOG_GS
WHERE to_char(starttime,'yyyy-mm-dd') = '&date'
GROUP BY to_char(starttime, 'hh24');
SELECT to_char(starttime, 'yyyy-mm-dd hh24') hour,count(1) every_hour_count
FROM CPAS_LOG.TABLOG_GS
GROUP BY to_char(starttime, 'yyyy-mm-dd hh24');