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'"); HELP PLEASE