J. Bobby Lopez <j...@...> writes:
[...]
> I'm having some trouble understanding how I would pull records within a
> specific date range (last five days for example).
[...]
a little prototyping:
SELECT yourfield01, yourfield02,...
FROM yourtable
WHERE julianday('now', '-6days') <
julianday('your_date_in_correct_form_see_doc')
greetings
Oliver
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
