删除早于x天的android SQLite行 [英] deleting android SQLite rows older than x days

问题描述

我想删除表MYTABLE中所有早于x天的行.列SAVE_DATE Long是将行插入表中的时间.

I want to delete all rows in table MYTABLE which are older than x days. Column SAVE_DATE Long is the time when the row was inserted in table.

我尝试了此操作，但显然它删除了我所有的行:

I tried this but apparently it deletes all my rows:

long daysInMiliSec = new Date().getTime() - X
            * (24L * 60L * 60L * 1000L);
return db.delete(MYTABLE , SAVE_DATE
            " <= ?", new String[] { "" + daysInMiliSec }

怎么了?

推荐答案

以下查询将删除2天之前的数据:

Below query will delete data older than 2 days:

String sql = "DELETE FROM myTable WHERE Save_Date <= date('now','-2 day')"; 
db.execSQL(sql);

这篇关于删除早于x天的android SQLite行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！