How to delete all records from a specific date to a specific date in SQLite3?

Question

MySQL

Let's say records in a certain database went to different tables from June to August. I only want to keep records from June to July. There are created / timestamp fields i.e. there is something to get away from. Or if you can still somehow navigate in time - write. We need to edit the database... Remove unnecessary entries.

Answer 1

select * from table where created between YYYY-MM-DD and YYYY-MM-DD;
and in the table where the INT field is, do date(field)