lundi 29 février 2016

In android Sqlite i want to search data by current week,month year and date range

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