How to convert milliseconds to date in SQLite

by

One of SQLite’s supported date/time formats is Unix timestamps, i.e., seconds since 1970.
To convert milliseconds to that, just divide by 1000.

Then use some date/time function to get the year and the month:

SELECT strftime('%Y-%m', MillisField / 1000, 'unixepoch') FROM MyTable

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  3. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  4. Android SQLite issue – table … has no column named
  5. How to perform an SQLite query within an Android application?
  6. Android: column ‘_id’ does not exist
  7. How can I insert image in a sqlite database
  8. How to store and retrieve a byte array (image data) to and from a SQLite database?
  9. A pre-populated database does not work at API 28 throws “no such table” exception
  10. How to store sqlite database directly on sdcard
  11. Attempt to reopen an already-closed object sqlitedatabase
  12. How insert image in room persistence library?
  13. How to check database on not rooted android device
  14. Where does Android emulator store SQLite database?
  15. Android database encryption
  16. Android error – close() was never explicitly called on database
  17. What is a maximum size of SQLite database on Android?
  18. How to save images into Database
  19. Full text search example in Android
  20. rawQuery(query, selectionArgs)
  21. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  22. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  23. How to view data saved in android database(SQLite)?
  24. SQLite exception: Database is locked issue
  25. How can I reset a autoincrement sequence number in sqlite
  26. Sqlite issues with HTC Desire HD
  27. PowerManager.PARTIAL_WAKE_LOCK android
  28. How to store JSON object in SQLite database
  29. Android SQLiteOpenHelper cannot open database file
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment