summaryrefslogtreecommitdiff
path: root/doc/includes/sqlite3/parse_colnames.py
blob: 702fa8d0c7f5eaf81d020ebe4eed97c319ae4f62 (plain)
1
2
3
4
5
6
7
8
from pysqlite2 import dbapi2 as sqlite3
import datetime

con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_COLNAMES)
cur = con.cursor()
cur.execute('select ? as "x [timestamp]"', (datetime.datetime.now(),))
dt = cur.fetchone()[0]
print dt, type(dt)