i want to sum the values of a column where date is today's date and pass it to a variable. i wrote the following code but it's not working.

> 
> error: "column name sum(Bill\_Total) not valid." its considering "sum(Bill\_Total)" as a column. 
> 
> 
> 

```
String sql = "select sum(Bill_Total) from t_report where date=?";
PreparedStatement pst = con.prepareStatement(sql);
pst.setDate(1, date);
ResultSet rs = pst.executeQuery();
String sum=rs.getString(sql);

```

can someone tell me whats wrong with my query. thanks in advance