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