CODEWITHSUNDEEP
android
Jovan
Jovan

Reputation: 4794

Android sqlite date comparison?

How can I compare dates using where statement in sqlite? I don't know how to write date in timestamp format in DB. I guess only timestamp format (integer or string in database) I can compare?!

Can someone help me with code for writing date in db (using ContentValues )

I want to use this code for comparison:

 Cursor mCursor =
             db.query(true,
               tableName,
               null, 
               KEY_DATETIME + " >= '"+ fromDate +"' and " +
                 KEY_DATETIME + " <= '"+ toDate +"'" , 
               null,
               null, 
               null, 
               null, 
               null);

Upvotes: 0

Views: 3389

Answers (1)

Robert Petermeier
Robert Petermeier

Reputation: 4152

You might consider storing the date as a long in the SQLite DB which has several advantages. See my other question and the accepted answer for more information.

Upvotes: 1

Related Questions