Compare dates (stored as string) in android sqlite database?

by

if you are storing dates as strings in the format

YYYY-MM-DD HH:mm:ss

====> then your date field is a DateTime datatype

Thus you have to use such query

select * 
  from MyTable 
  where mydate >= Datetime('2000-01-01 00:00:00') 
  and mydate <= Datetime('2050-01-01 23:00:59')

you can also use the snippet given by @Joop Eggen with th between operator it’s th same approche.

The BETWEEN operator is logically equivalent to a pair of comparisons. “x BETWEEN y AND z” is equivalent to “x>=y AND x<=z” except that with BETWEEN, the x expression is only evaluated once. see sqlite3 docs

More Related Contents:

  1. Best way to work with dates in Android SQLite [closed]
  2. I am getting this error on my code [closed]
  3. Sqlite for Android
  4. How can I avoid concurrency problems when using SQLite on Android?
  5. How to format date and time in Android?
  6. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  7. How do I join two SQLite tables in my Android application?
  8. How can I create a user-defined function in SQLite?
  9. SQLite Android Database Cursor window allocation of 2048 kb failed
  10. Android DatePicker change to only Month and Year
  11. Android SQLite: Update Statement
  12. How to delete SQLite database from Android programmatically
  13. How do I create a database in android? [closed]
  14. Android SimpleCursorAdapter doesn’t update when database changes
  15. How to implement Export sqlite To excel/csv file in android?
  16. How to store and retrieve a byte array (image data) to and from a SQLite database?
  17. problem about sqlite database, no such table:
  18. SQLite Query in Android to count rows
  19. Using the LIMIT statement in a SQLite query
  20. sqlite encryption for android
  21. Retrieve large blob from Android sqlite database
  22. Attempt to reopen an already-closed object sqlitedatabase
  23. How insert image in room persistence library?
  24. How to access an existing sqlite database in Android?
  25. DB File in Assets Folder. Will it be Updated?
  26. Date picker in Android
  27. Get SQLite database from Android app
  28. SQLite database on SD card
  29. Does Android SQLite cursor load all records into memory at once?
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment