Sqlite SELECT * in the last 7 days

Question

I am trying to do SELECT * to retrieve rows in the last 7 days in SQLite.

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 should I do it? Im new on this

Answer 1

SELECT * FROM session WHERE stop_time > (SELECT DATETIME('now', '-7 day'))

Refer to the documentation