Date and Time issue in SQL statement 1

[royyan]

I had some difficuties to create the SQL statement which calculates the average hits for each hour of the day in a period(such as from 04/01/02 to 04/10/02). The following is my sample statement.
"select count(Hit) as HitCounts from MyTable where Date between '" & fromDate & "' and '" & toDate & "' group by datepart(hh, Date)"

Thanks for help

 

[Mighty]

Try:

"select hour(Date) as myHour, count(*) as HitCounts from MyTable where Date between '" & fromDate & "' and '" & toDate & "' group by hour(Date)" Mighty

 

[royyan]

This works perfect on my code. Thanks a lot!