mercredi 4 novembre 2015

Get all dates by month in android database

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