udDRAB7X

1long daysInMiliSec = new Date().getTime() - X
2            * (24L * 60L * 60L * 1000L);
3return db.delete(MYTABLE , SAVE_DATE
4            " <= ?", new String[] { "" + daysInMiliSec }
5	
6String sql = "DELETE FROM myTable WHERE Save_Date <= date('now','-2 day')"; 
7db.execSQL(sql);
8	
9CREATE TABLE IF NOT EXISTS test (id INTEGER PRIMARY KEY, text TEXT, age INTEGER)
10	
11INSERT INTO test (text, age) VALUES ("bla", datetime('now'))
12	
13SELECT * FROM test WHERE age <= datetime('now', '-5 minutes')
14	
15String sql = "DELETE FROM graph WHERE time <= 1522405117";
16                        dbHelper.getWritableDatabase().execSQL(sql);