/Doc/includes/sqlite3/pysqlite_datetime.py
http://unladen-swallow.googlecode.com/ · Python · 20 lines · 16 code · 4 blank · 0 comment · 0 complexity · 1da51ecb043d87e5763b16778c9a1302 MD5 · raw file
- import sqlite3
- import datetime
- con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES|sqlite3.PARSE_COLNAMES)
- cur = con.cursor()
- cur.execute("create table test(d date, ts timestamp)")
- today = datetime.date.today()
- now = datetime.datetime.now()
- cur.execute("insert into test(d, ts) values (?, ?)", (today, now))
- cur.execute("select d, ts from test")
- row = cur.fetchone()
- print today, "=>", row[0], type(row[0])
- print now, "=>", row[1], type(row[1])
- cur.execute('select current_date as "d [date]", current_timestamp as "ts [timestamp]"')
- row = cur.fetchone()
- print "current_date", row[0], type(row[0])
- print "current_timestamp", row[1], type(row[1])