summaryrefslogtreecommitdiff
path: root/sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py
diff options
context:
space:
mode:
authorcinap_lenrek <cinap_lenrek@localhost>2011-05-03 11:25:13 +0000
committercinap_lenrek <cinap_lenrek@localhost>2011-05-03 11:25:13 +0000
commit458120dd40db6b4df55a4e96b650e16798ef06a0 (patch)
tree8f82685be24fef97e715c6f5ca4c68d34d5074ee /sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py
parent3a742c699f6806c1145aea5149bf15de15a0afd7 (diff)
add hg and python
Diffstat (limited to 'sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py')
-rw-r--r--sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py14
1 files changed, 14 insertions, 0 deletions
diff --git a/sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py b/sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py
new file mode 100644
index 000000000..34604985c
--- /dev/null
+++ b/sys/src/cmd/python/Doc/lib/sqlite3/adapter_datetime.py
@@ -0,0 +1,14 @@
+import sqlite3
+import datetime, time
+
+def adapt_datetime(ts):
+ return time.mktime(ts.timetuple())
+
+sqlite3.register_adapter(datetime.datetime, adapt_datetime)
+
+con = sqlite3.connect(":memory:")
+cur = con.cursor()
+
+now = datetime.datetime.now()
+cur.execute("select ?", (now,))
+print cur.fetchone()[0]