is this... 2015-01-02 20:47:18 (this is datetime( 'now', '-3600 second' ) received = 2015-01-02 13:46:23.818-0800 this is a DATETIME column recorded in the database
recieved2 = 2015-01-02 15:46:20.000-0600 this is a DATETIME column recorded in the database 13- (-8) = 21 which is more than NOW 16-(-6) = 21 which is also more than NOW select * from messages where received < datetime( 'now', '-3600' ) do I have to do something like delete from messages where datetime(received) < datetime( 'now', '-3600' ) ? to apply the function to the column again? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users