Sqlite SELECT * for Last 7 days

Im trying to do a SELECT * to retrieve rows for last 7 days in SQLite.

the table structure is as follows

CREATE TABLE 'session' ('rowID' INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , 'steps' INTEGER, 'stop_time' DATETIME NOT NULL  DEFAULT CURRENT_TIMESTAMP)

How do I do this? Im new at this

6
задан Jason 3 September 2010 в 09:40
поделиться