Difference between 2 dates in SQLite

by 
 SELECT julianday('now') - julianday(DateCreated) FROM Payment;

More Related Contents:

  1. SQLite how to refer to column name by a query
  2. How do I unlock a SQLite database?
  3. “Insert if not exists” statement in SQLite
  4. SQLite Concurrent Access
  5. System.Data.SQLite Close() not releasing database file
  6. Escape single quote character for use in an SQLite query
  7. INSERT IF NOT EXISTS ELSE UPDATE?
  8. Sqlite LIMIT / OFFSET query
  9. Set start value for AUTOINCREMENT in SQLite
  10. How to use ROW_NUMBER in sqlite
  11. Update with Join in SQLite
  12. Can I read and write to a SQLite database concurrently from multiple connections?
  13. How do I store and retrieve a blob from sqlite?
  14. ALTER COLUMN in sqlite
  15. SQLite error ‘attempt to write a readonly database’ during insert?
  16. Efficient paging in SQLite with millions of records
  17. Store boolean value in SQLite
  18. Encrypted cookies in Chrome
  19. How delete table inner join with other table in Sqlite?
  20. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  21. How to get a list of column names
  22. sqlite – How to get INSERT OR IGNORE to work
  23. Creating stored procedure and SQLite?
  24. How Scalable is SQLite? [closed]
  25. How do DATETIME values work in SQLite?
  26. change sqlite file size after “DELETE FROM table”
  27. How to set unique constraint over multiple columns when any one can be null?
  28. sql query – how to apply limit within group by
  29. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  30. Creating stored procedure in SQLite

Leave a Comment