For my list view using simple cursor adapter I want to display the date as dd-MM-yyyy. In my table I store date as yyyy-MM-dd in TX_DATE column. How to make it out in the following code:
SQLiteDatabase db = helper.getReadableDatabase();
String[] columns = {VivzHelper.UID, helper.TX_NAME,
"SUM("+helper.TX_AMOUNT+") AS "+helper.TX_AMOUNT,
helper.TX_DATE};
Cursor c = db.query(VivzHelper.TX_TABLE, columns, helper.TX_ID + "='" +
name + "' AND " + helper.TX_DATE + " BETWEEN '"
+ datefrom.from_date + "' AND '" + dateto.to_date + " '
",null,helper.TX_NAME, null, null);
Aucun commentaire:
Enregistrer un commentaire