[thelist] SQL Problem

Sun May 6 18:47:19 CDT 2001

Hello to everyone out there

I have a problem with an SQL query. I am using ASP with SQL Server 7 on
Windows NT 4.0 Server. The problem is this:
I have this table

Timestamp                        Value
------------------------------------
01/01/2000  01:00              10.8
01/01/2000  02:00                8.6
01/02/2000  01:00                9.7
01/02/2000  02:00                9.5

And I want to get the average value for each day. i.e. I want these results

Date                      Average
01/01/2000               9.7
01/02/2000               9.6

Thank you for your help.
                        Marios