When getting data between a range of dates you can use:
WHERE date >= DATE('now', '-7 days')
AND date < DATE('now')
or:
WHERE date BETWEEN
DATE('now', '-7 days')
AND DATE('now', '-1 days')
Is there a preferred way? In a way I like the second better.
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
