Andorid sqlite date comparation?

Question

Hi,

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 comparation:

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

Thanks

Answer 1

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.