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