day month year 都有了. 可是还有一个分钟的函数没有

[lovebanyi]

任务,是统计 某一天24个小时段的流量


如果有 小时函数的话就办了

select count(*),小时(datetime) from ip group by 小时(datetime)

这样就可以取出来了.

所以需要一个小时的自定义函数

[jinjazz]

datepart(hh,datetime)

[lovebanyi]

OK 谢谢.哪如果要自己写.应该什么写呢

[生活真美好]

select count(*),left(right(CONVERT(varchar(19), datetime1, 121),8),2) AS datetime1
from ip
group by left(right(CONVERT(varchar(19), datetime1, 121),8),2) AS datetime1

[生活真美好]

select count(*),left(right(CONVERT(varchar(19), datetime1, 121),8),2) AS datetime1
from ip
group by left(right(CONVERT(varchar(19), datetime1, 121),8),2)

[生活真美好]

select count(*),DATEPART(hh, datetime1) AS datetime1
from ip
group by DATEPART(hh, datetime1)