I can't seem to get reliable results from the query against a SQLite database using a DateTime string as a comparison as so:
SELECT *
FROM table_1
WHERE mydate BETWEEN '01-01-2016 05:10:00' AND '10-01-2016 17:10:00'
mydate column is stored as DD-MM-YYYY HH:MM:SS format
How to get records between these two DateTime range.
Aucun commentaire:
Enregistrer un commentaire