On Sep 16, 2009, at 10:02 PM, sqlite-users-requ...@sqlite.org wrote:

> WHERE birth BETWEEN date('now','-24 years') AND date('now','-12
> years')

Thank you Igor and D. Richard for your explanations and assistance.  I  
understand better now how the date comparisons function.  Also, thank  
you Igor for pointing out my redundant nested SELECT statement.

Craig Smith
cr...@macscripter.net



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to