Doc/includes/sqlite3/pysqlite_datetime.py

   1 import sqlite3
   2 import datetime
   3
   4 con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES|sqlite3.PARSE_COLNAMES)
   5 cur = con.cursor()
   6 cur.execute("create table test(d date, ts timestamp)")
   7
   8 today = datetime.date.today()
   9 now = datetime.datetime.now()
  10
  11 cur.execute("insert into test(d, ts) values (?, ?)", (today, now))
  12 cur.execute("select d, ts from test")
  13 row = cur.fetchone()
  14 print today, "=>", row[0], type(row[0])
  15 print now, "=>", row[1], type(row[1])
  16
  17 cur.execute('select current_date as "d [date]", current_timestamp as "ts [timestamp]"')
  18 row = cur.fetchone()
  19 print "current_date", row[0], type(row[0])
  20 print "current_timestamp", row[1], type(row[1])