How do you do a datetime based query using SQLite in Python?

Question

import sqlite3
import datetime

today = datetime.date.today()

db_name = "test.db"
db = sqlite3.connect(db_name, detect_types=sqlite3.PARSE_DECLTYPES)
c = db.cursor()
c.execute('create table changes (type string, file_name string, modified timestamp)')
c.execute('insert into changes values(?, ?, ?)', ('M', 'source/test-this.rst', datetime.datetime.now()))
db.commit()
last_run = datetime.datetime(2012, 2, 27, 23, 22, 21, 613477)
c.execute('''select modified from changes where modified > ?''', (last_run))
print c.fetchall()

I'm getting this error...

$ python sqlite.py 
Traceback (most recent call last):
  File "sqlite.py", line 18, in <module>
    c.execute('''select modified from changes where modified > ?''', (last_run))
ValueError: parameters are of unsupported type

Eric O. Lebigot · Accepted Answer · 2012-02-28 06:14:29Z

4

Simply use a tuple:

c.execute('''select modified from changes where modified > ?''', (last_run,))

This is a common gotcha…

answered Feb 28, 2012 at 6:14

Eric O. Lebigot

95.1k49 gold badges223 silver badges263 bronze badges

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

Collectives™ on Stack Overflow

How do you do a datetime based query using SQLite in Python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related