| Georg Brandl | 116aa62 | 2007-08-15 14:28:22 +0000 | [diff] [blame^] | 1 | import sqlite3 |
| 2 | import datetime, time | ||||
| 3 | |||||
| 4 | def adapt_datetime(ts): | ||||
| 5 | return time.mktime(ts.timetuple()) | ||||
| 6 | |||||
| 7 | sqlite3.register_adapter(datetime.datetime, adapt_datetime) | ||||
| 8 | |||||
| 9 | con = sqlite3.connect(":memory:") | ||||
| 10 | cur = con.cursor() | ||||
| 11 | |||||
| 12 | now = datetime.datetime.now() | ||||
| 13 | cur.execute("select ?", (now,)) | ||||
| 14 | print(cur.fetchone()[0]) | ||||