How can I find records on two dates in SQLite ?
In mysql I know it's through BETWEEN , but I do not know how it does in SQLIte.
Find values between two dates in SQLIte
0
asked by anonymous 29.03.2018 / 16:52
1 answer
1
SQLite uses BETWEEN as stated in the comment, following example:
SELECT * FROM Pessoa WHERE Data BETWEEN '2000-01-01' AND '2015-01-01'
Note: If you tried with BETWEEN and did not get the problem may be in date format, SQLite expects the date to be in YYYY-MM-DD format, it might be treating your search as string .
Source: link
29.03.2018 / 17:05