git: 9front

ref: 69b8ba83efb8a78c454b342bc2c6c3d2c4c1e268
dir: /sys/src/cmd/python/Doc/lib/sqlite3/parse_colnames.py/

View raw version 
import 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)