I have a sqlite table and i want to delete a row from that table at the end of each month. Is there a way to do that in Android

Question

I have an SQLite table and I want to run a query at the end of each month to delete a row from the table, is there a way to do so?

use workmanger and schedule a task every 30 days. https://stackoverflow.com/questions/53901179/android-work-manager-how-to-enqueue-jobs-once-a-month — akshay_shahane, Feb 02 '21 at 07:05

Peppinhood · Answer 1 · 2021-02-02T12:23:45.673

To delete a row just use:

    db.delete(String table, 
            String whereClause, 
            String[] whereArgs)

ex.

    db.delete("yourTable", "yourRow", null);

Now to recognize the day of the month use Calendar class:

Calendar calendar = Calendar.getInstance();
int dayOfTheMonth = calendar.get(Calendar.DAY_OF_MONTH);

1 Answers1