pythonsqlite3-python

How to delete the dates? (sqlite3)

This is my data base

I want to delete all the dates with day 26, for example But code like this doesn't work:

CURSOR.execute(f"SELECT * FROM {name}_schedule WHERE date == {date}")

I do not know sql at all, so idk what to do :c

Solution

  • The sql could be something like this

    DELETE FROM table_name WHERE strftime('%d', date_column) = '26'