How to select values ​​that were loaded a day ago from a date in a table?

Question

SQLite

I have a table like this:


I need to select values ​​from there that were uploaded more than one day ago.

That is, only one value is suitable from this table.

Answer 1

c.execute("select * from mytable where date < date('now', '-1 day')")