终于我找到了解决自己问题的方法

以下是对我有用的代码

```
DateFormat dateFormat = new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”);
Date date = new Date();
Calendar calendar = Calendar.getInstance();
String startDate = dateFormat.format(date);
String endDate = “”;
for (int i = 1; i <= 24; i++) {
System.out.println(“Start Date:- ” + startDate);
calendar.add(Calendar.HOUR_OF_DAY, -1);
date = calendar.getTime();
endDate = dateFormat.format(date);
System.out.println(“End Date:- ” + endDate);
String data = dbAdapter.getOutDoorHourlyData(startDate, endDate);
System.out.println(“Hourly Average:- ” + data);
startDate = endDate;
endDate = “”;
}

public String getOutDoorHourlyData(String startDate, String endDate) {
double outdoorHourly = 0;

    Cursor cursor = _sqliteDB.rawQuery("Select AVG("
            + COLOUMN_NAME + ") from (Select * FROM "
            + TABLE_NAME + " where " + COLOUMN_NAME + " >= '"
            + endDate + "' and " + COLOUMN_NAME + " < '" + startDate
            + "')", null);

    try {

        if (cursor != null) {
            if (cursor.getCount() > 0) {
                cursor.moveToFirst();
                do {
                    outdoorHourly = cursor.getDouble(0);
                } while (cursor.moveToNext());
            }
            cursor.close();
        }
    } catch (Exception e) {
        e.printStackTrace();
    }

    String hourlyData = decimalFormat.format(outdoorHourly);
    hourlyData = hourlyData.replace(",", ".");
    return hourlyData;

}

}
```

希望以后能对某人有所帮助