mardi 1 décembre 2015

E/SQLiteLog: (1) near "day": syntax error

I would want to remove data from sqlite x days from now my device_time column is milliseconds.

DELETE FROM aalast_update WHERE strftime('%Y-%m-%d',  device_time/ 1000, 'unixepoch') <= datetime('now' , -60 day)

Is there something im missing? Or is there any other way Im not seeing from the docs?

Aucun commentaire:

Enregistrer un commentaire