jeudi 23 avril 2015

How to change date format to dd-MM-yyyy for simplecursoradapter list view using cursor query

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