lundi 4 avril 2016

How I can get all last year's records of SQLite table

I have a table in which each record has a date. I want to get records based on the last 365 days.

Select name FROM Contacts WHERE date = julianday('now') - julianday('365'); 

is this correct?

Aucun commentaire:

Enregistrer un commentaire