/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

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