jeudi 24 mars 2016

Select range on SQLite DateTime comparison

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