Postgresql: How to delete rows from table constrained by date?

Question

I am using psycopg2 and how can I delete rows that are older than a certain date? For example:

cursor.execute('DELETE FROM datatable WHERE date < %s', datetime.date(2012, 1, 1))

If I write like this, there will be TypeError: 'datetime.date' object does not support indexing. How can I do with it? Thanks!

falsetru · Accepted Answer · 2013-12-23 06:00:04Z

3

Pass the second argument as a list or a tuple:

cursor.execute('DELETE FROM datatable WHERE date < %s', [datetime.date(2012, 1, 1)])

answered Dec 23, 2013 at 6:00

falsetru

371k69 gold badges770 silver badges660 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1