0

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);
Nicolas Kaiser
  • 1,628
  • 2
  • 14
  • 26
Jovan
  • 4,684
  • 13
  • 64
  • 98

1 Answers1

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.

Community
  • 1
  • 1
Robert Petermeier
  • 4,122
  • 4
  • 29
  • 37