I have database where I have table in database where one of column is for date in Long. There is any simple way to get all dates by month? For example I need all dates for october. For day I use:
public static List<Plan> getPlanListByMonth(SQLiteDatabase db, DateTime date) {
String where = "date" + " = '"+ "2015-11-04" +"'";
Cursor cursor = db.query(TABLE_NAME, null, where,
null, null, null, null, null);
return getPlanList(cursor);
}
but I have no idea how create "where" condition to get all values by month.
Aucun commentaire:
Enregistrer un commentaire