You said you need to keep something like 30 days, right? Why convert at all?
What's wrong with this: delete from mytable where mytime < max(mytime)-30 If you want to round it off to whole days: delete from mytable where mytime < round(max(mytime)-.5)-30 Or is there something else you need to do? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
