How do I make a comparison between dates using SQlite, I tried this more failed. help: D
My Query:
SELECT
latitude,
longitude,
grupo_crime_id_grupo_crime,
descricao,
id_crime,
cities_id_cities,
time,
estado
FROM crime WHERE
cities_id_cities='0' AND
time >= datetime('2013-03-28T09:30:37-03:00')
time <= datetime('2013-0328T09:30:37-03:00') AND
grupo_crime_id_grupo_crime='1'