This is my table.
CREATE TABLE Income (id INTEGER PRIMARY KEY AUTOINCREMENT, type TEXT, amount DOUBLE, sdate DATE, way TEXT,desc TEXT)
And after that i want to search date sort by sdate column
this is my queary but no out put from this quary.
SELECT * from Income where sdate=DATE('now', 'weekday 0', '-7 days')
Aucun commentaire:
Enregistrer un commentaire