by using your given example I tried
select convert(varchar(20), Reading_Date), sum(Fuel_Level) as fuel from dbo.Levels
where convert(date,Reading_Date)=convert(date,getdate())
group by Convert (varchar(20),Reading_Date)
order by convert(datetime, convert(varchar(20),Reading_Date))
it displaying like this :
Sep 6 2012 12:00AM179152.80
Sep 6 2012 12:15AM179509.60
Sep 6 2012 12:30AM180141.50
Sep 6 2012 12:45AM180243.30
Sep 6 2012 1:00AM180227.70
Sep 6 2012 1:15AM180196.60
Sep 6 2012 1:30AM180175.20
I want in output to sum up fuel_level from 6 2012 12:00AM to 6 2012 12:45AM and dispaly date as sep 6 2012
-- expected output
date hour fuel_level
2012-09-06 0 50
2012-09-06 1 500
- - -
- - -
2012-09-06 24 2530
cheers
-