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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
