Deleting from android sqlite table

I have a column in android sqlite database table. The values in the column are l开发者_开发问答ike:

2011/06/01
2011/06/02
2011/06/05
2011/06/10
2011/06/11
2011/06/13
2011/06/15
2011/06/16
2011/06/25
2011/06/26

I have a string today="2011/06/27"

Now I want to delete those rows whose column value is older than 5 days from today.

How to modify the code to achieve this?

return db.delete(DATABASE_TABLE,where date="", null) > 0;

You have to store your dates in a other format, check the date function of SQLite. Use YYYY-MM-DD instead of YYYY/MM/DD. You already got an order on your dates defined by its string representation. So you can use the date function of SQLite to select the correct rows.

Dates older than 5 days would be queried like this.

... WHERE datecolumn < date('now', '-5 days') ...

There is no date type in sqllite

you just store a data represented value as a string or int

then use the date based functions of sqllite to get the values

You should be using the stored procedure rather than writing the service. It will make easier for your application to automatically update the records.

See link: http://searchoracle.techtarget.com/answer/Time-based-stored-procedure-to-check-table-and-update-old-records

Another solution is to use date instead of string. When you run your service then fetch data as Date and then you can make the simple comparison.