On Sep 17, 2009, at 12:53 AM, Igor Tandetnik wrote:
>
>> Is there
>> any way I can make the SELECT more precise?
>
> Try this:
>
> WHERE ( date('now') - birth - (substr(date('now'), 6) < substr(birth,
> 6)) )
> BETWEEN 12 and 24
>
I didn't think about the BETWEEN operator. How about this:
WHERE birth BETWEEN date('now','-24 years') AND date('now','-12
years')
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
