Question

I have a folowing code for getting records from a datbase in ascending order public Cursor fetchAllRemindersD() {

    return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_TITLE,
            KEY_BODY, KEY_PHONE,KEY_DATE_TIME}, null, null, null, null,KEY_DATE_TIME +  " ASC");
}

The dates are stored in string format. What should i do inorder to get the records with dates having either present date or upcoming dates..

Answer 1

你们想要的是:

mDB.query(
    DATABASE_TABLE, 
    new String[] {KEY_ROWID, KEY_TITLE, KEY_BODY, KEY_PHONE, KEY_DATE_TIME}, 
    KEY_DATE_TIME + " >= ?", 
    new String[]{Long.toString(System.currentTimeMillis())}, 
    null, null, KEY_DATE_TIME +  " ASC");

... assuming your dates are stored in epoch format.

Answer 2

这取决于你储存数据库的日期。如果你在YYYYYMMDD格式中储存日期,你可以很容易地应用和提炼;而且,在你的询问中,操作者可以查阅和查阅记录。例如,20111110年的水平一直高于20111109。

Answer 3

It depends how you have stored the data in the db. If its a unixtime stamp then get the current date and return entries that are higher then that value.

你们将需要以下东西:

long timeStamp = System.currentTimeMillis() / 1000;


String myQuery = "SELECT * FROM " + DATABASE_TABLE +" WHERE" + KEY_DATE_TIME + "=?";
mDb.rawQuery(myQuery, new String[] {timeStamp});

友情链接