Skip to main content

Browse the archive

Staging
v0.5.1
https://github.com/python/cpython
09 December 2020, 11:06:31 UTC
Revision 87e691240b5b16b622a6e91acea89673de601d63 authored by Raymond Hettinger on 03 March 2015, 07:32:02 UTC, committed by Raymond Hettinger on 03 March 2015, 07:32:02 UTC 
Minor neatening-up.  Make assignments in same order a struct fields.  Line-up comments.
1 parent f9d9c79
Raw File
Tip revision: 87e691240b5b16b622a6e91acea89673de601d63 authored by Raymond Hettinger on 03 March 2015, 07:32:02 UTC
Minor neatening-up. Make assignments in same order a struct fields. Line-up comments.
Tip revision: 87e6912
pysqlite_datetime.py 
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]))
back to top