i have a database and along with multiple record of same date and related amount
===

i have a database and along with multiple record of same date and related amount but i want to only single record and that is **date related total amount**

No.       Date                   name   amt
----    -----------------------  -----  ----
4	2012-07-27 10:47:50.000	 zerox	15	
5	2012-07-27 12:22:16.000	 bag	30	
6	2012-07-28 10:47:50.000	 zerox	25	
7	2012-07-28 12:22:16.000	 bag	30	


i want like this:
-----------------
date         totamt
----------   -------
2012-07-27   45
2012-07-28   55