Re: [sqlite] Date/Time query help

Marco Bambini wrote: > 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

[sqlite] Date/Time query help

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