I'm working on an SQLite database. I need to obtain a list of people who have between a minimum age and a maximum age.
In my table
SELECT login FROM person WHERE ((JulianDay('now')) - (JulianDay(birth))/365) > 5
Currently you do
n - m / 365 and division is done before subtraction. :-)
(JulianDay('now') - JulianDay(birth)) / 365