Hi

I have two things my customer wants.


1.
In my DB there is a table containing some data of what had happend
during some time.
This table contains a field, definded as DATE.
I contains both date and time.

Now I would like to do a select like:

Select
MyDate
Sum(Field1)
from MyTable
Group by MyDate.

This results gives me a lot of records of the same day because of the
time.
I would like to eliminate the time, so to get a sum of the entire day.


2.
As above, but I would like to group by every hour of every day.
My customer would like to se something like this:

2003.02.20 at 13.00-14.00 Something
2003.02.20 at 14.00-15.00 Something
2003.02.20 at 15.00-16.00 Something
etc.


Is this posible ?

Regards
Michael