I have a table like: CREATE TABLE foo (id integer PRIMARY KEY AUTOINCREMENT,connection_date text);
and I insert data into this table using the syntax: INSERT INTO foo (connection_date) VALUES (datetime('now','localtime')); INSERT INTO foo (connection_date) VALUES (datetime('now','localtime')); I really need to use localtime and after the two simple INSERT above my table contains rows like: id connection_date 1 2010-12-07 14:39:43 2 2010-12-07 14:39:59 I need to create a query that is able to retrieve all the id(s) from foo where connection_date is older than 5 minutes starting from now (in localtime). Thanks a lot. -- Marco Bambini http://www.sqlabs.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users