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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
