Reading back a datetime in sqlite3
You have to set detect_types to sqlite.PARSE_COLNAMES and use as "foo [timestamp]" like this:
import sqlite3import datetimedb = sqlite3.connect(':memory:', detect_types = sqlite3.PARSE_COLNAMES)c = db.cursor()c.execute('create table foo (bar integer, baz timestamp)')c.execute('insert into foo values(?, ?)', (23, datetime.datetime.now()))c.execute('insert into foo values(?, ?)', (42, datetime.datetime.now() + datetime.timedelta(-1)))c.execute('select bar, baz as "ts [timestamp]" from foo')print c.fetchall()c.execute('select max(baz) as "ts [timestamp]" from foo')print c.fetchall()Did a nice little Google search and found this message.