I’m having some trouble working with dates on my Android application that uses SQLite.
I have a couple questions:
- What type should I use to store dates in SQLite (text, integer, …)?
- Given the best way to store dates how do I store It properly using ContentValues?
- What’s the best way to retrieve the date from the SQLite database?
- How to make a sql select on SQLite, ordering the results by date?