How to generate all dates between two dates

by

This is not possible without a recursive common table expression, which was introduced in SQLite 3.8.3:

WITH RECURSIVE dates(date) AS (
  VALUES('2015-10-03')
  UNION ALL
  SELECT date(date, '+1 day')
  FROM dates
  WHERE date < '2015-11-01'
)
SELECT date FROM dates;

More Related Contents:

  1. How do I unlock a SQLite database?
  2. Best way to work with dates in Android SQLite [closed]
  3. How to delete or add column in SQLITE?
  4. How to use ROW_NUMBER in sqlite
  5. Android – Pulling SQlite database android device
  6. How to get Top 5 records in SqLite?
  7. Insert new column into table in sqlite?
  8. How do you enable LIMIT for DELETE in SQLite?
  9. SQLite Schema Information Metadata
  10. How to create custom functions in SQLite
  11. Sqlite group_concat ordering
  12. Select entries between dates in doctrine 2
  13. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  14. is there a limit to the size of a SQLite database?
  15. Does it matter what extension is used for SQLite database files?
  16. sqlite – How to get INSERT OR IGNORE to work
  17. How do I DROP a constraint from a sqlite (3.6.21) table?
  18. How do I add a new column in between two columns?
  19. change sqlite file size after “DELETE FROM table”
  20. Are there any reserved words in SQLite?
  21. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  22. Modify a Column’s Type in sqlite3
  23. Case sensitive and insensitive like in SQLite
  24. SQLite accent-insensitive search
  25. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  26. SQLite for large data sets?
  27. Compare dates (stored as string) in android sqlite database?
  28. SQLite database supporting Unicode data
  29. Creating stored procedure in SQLite
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment