Before I run my query, the value_timestamp field of my table contains: 2009-05-07 17:00:43
My query is: delete from trend_data where datetime(value_timestamp) < '4/7/2009 12:37:32 PM' Your times are in different formats - yyyy-mm-dd hh-mm-ss is what you state is in the database. You should use the same format in your query. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users