对于使用简单光标适配器的列表视图,我想将日期显示为 dd-MM-yyyy。在我的表中,我将日期存储为 yyyy-MM-dd TX_DATE列中。如何在以下代码中使其出来:
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);
根据您的要求修改以下代码(我已根据需要更改的日期格式),以所需的格式获取日期:
String givenDateString = dateTime;// dateTime variable is the variable in which you are storing the date currently
SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy", Locale.ENGLISH);
sdf.setTimeZone(TimeZone.getTimeZone("GMT+0530"));
try {
Date mDate = sdf.parse(givenDateString);
timeInMilliseconds = mDate.getTime();
} catch (ParseException e) {
e.printStackTrace();
}
希望这有帮助。