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 c

Solution 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.