SQLite Forum

select between two dates
I have a sqlite3 database from which i wish to extract date between 14 days before the query.
my time data is held as interger secs in col ID and i can use the BETWEEN selection if i give the req as like '5900000'
 and '7777777'   note the ' s.
 however 'now'-12 days and 'now'
 or it many possibilities dosnt work
actual line is 
for row in cursor.execute(!SELECT * FROM env3 WHERE ID BETWEEN 'now'-(14*24*12*60*^) AND 'now'");