jeudi 1 octobre 2015

How to apply SELECT date('now') query in android?

I am working on a project and now I have been stuck on a weird stage.

I know that we can execute any query that has to do anything with database we can write that using:

Cursor cursor = db.rawQuery("SELECT * FROM table_name", null);

But now I want to execute this query:

"SELECT strftime('%s','now','-2 day')"

Generally the above query returns unixepoch time of one day before yesterday.

Does anyone know how can I get this done?

Aucun commentaire:

Enregistrer un commentaire