I have a load of data in a table which has a date_time column (i.e. in format 2002-02-28 12:39:45) that specifies when the data was inserted.
I also have another column (named 'amount') in this table that contains integer values.
What I'd like to do is add the values (i.e. SUM(amount)) in the amount column based upon time.

For example, I want to add up all the amounts for each day of the month. I.e. there may be 100 rows for one day each containing a different amount.

I'd like the results to be returned as:

Totals Date

5 2001/01/01
8 2001/01/02
7 2001/01/03


Does anyone know how to do this please?

Thank you,