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);