Best way to work with dates in Android SQLite [closed]

by

The best way is to store the dates as a number, received by using the Calendar command.

//Building the table includes:
StringBuilder query=new StringBuilder();
query.append("CREATE TABLE "+TABLE_NAME+ " (");
query.append(COLUMN_ID+"int primary key autoincrement,");
query.append(COLUMN_DATETIME+" int)");

//And inserting the data includes this:
values.put(COLUMN_DATETIME, System.currentTimeMillis());

Why do this? First of all, getting values from a date range is easy. Just convert your date into milliseconds, and then query appropriately. Sorting by date is similarly easy. The calls to convert among various formats are also likewise easy, as I included. Bottom line is, with this method, you can do anything you need to do, no problems. It will be slightly difficult to read a raw value, but it more than makes up that slight disadvantage with being easily machine readable and usable. And in fact, it is relatively easy to build a reader (And I know there are some out there) that will automatically convert the time tag to date as such for easy of reading.

It’s worth mentioning that the values that come out of this should be long, not int. Integer in sqlite can mean many things, anything from 1-8 bytes, but for almost all dates 64 bits, or a long, is what works.

EDIT: As has been pointed out in the comments, you have to use the cursor.getLong() to properly get the timestamp if you do this.

More Related Contents:

  1. Could not allocate CursorWindow
  2. android, how to exec a sql file in sqlitedatabase
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Android SQLite database: slow insertion
  5. Pros and Cons of SQLite and Shared Preferences [closed]
  6. Share SQLite database between 2 android apps?
  7. Android: upgrading DB version and adding new table
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. Android SQLite Example [closed]
  10. Android database encryption
  11. Best place to close database connection
  12. How to split comma-separated value in SQLite?
  13. Cursor adapter and sqlite example [closed]
  14. How to add new Column to Android SQLite Database?
  15. How to retrieve data from sqlite database in android and display it in TextView
  16. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  17. How do I create a database in android? [closed]
  18. How to save images into Database
  19. Android SimpleCursorAdapter doesn’t update when database changes
  20. Android SQLite Database, WHY drop table and recreate on upgrade
  21. How does one check if a table exists in an Android SQLite database?
  22. Android multiple databases open
  23. sqlite select with condition on date
  24. Create SQLite database in android
  25. SQLiteOpenHelper – creating database on SD card
  26. How to store JSON object in SQLite database
  27. Compare dates (stored as string) in android sqlite database?
  28. H2 Database vs SQLite on Android [closed]
  29. sqlite insert into table select * from
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment