KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I try storing date and time in SQLite3 with the intention of retrieving the records using comparisons later e.g. SELECT * WHERE date1 < date2 . I gave up trying to store datetime.datetime objects and decided to use a UNIX timestamp instead as they are just an int but I am still getting errors. import sqlite3 as lite import datetime import time conn = lite.connect('dispatcher.db') cur = conn.cursor() query = "create table if not exists new_test (curent_dt)" cur.execute(query) conn.commit() now = datetime.datetime.now() - datetime.timedelta(minutes=60) temp = int(time.mktime(now.timetuple())) cur.execute('insert into new_test (curent_dt) values (? )', (temp)) conn.commit() conn.close() Returns error : cur.execute('insert into new_test (curent_dt) values (? )', (temp)) ValueError: parameters are of unsupported type
Tags (comma-separated)
Save Edits
Cancel