Storing python dates in sqlite3

Question

is not there any way to store python dates or pyqt4 dates (QDate) in sqlite3 ? I'd not like to use sqlite's date types since i'll need to find the difference between dates that i'll store.That's what i'm trying :

    record = QtCore.QDate.currentDate()
    latest = self.calendar.selectedDate()

    db = sql.connect(":memory:")
    cur = self.db.cursor()
    cur.execute("CREATE TABLE  invoices(record, latest)")
    cur.execute("INSERT INTO invoices VALUES (?, ?)", (record, latest)) 
    db.commit()

That's the error : sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported type. Thanks in advance.

You can always pickle your object and store it as BLOB in your DB, although that might be overkill depending on your needs... docs.python.org/library/pickle.html — user610650
– user610650, Commented Jul 8, 2011 at 10:32

Ignacio Vazquez-Abrams · Accepted Answer · 2011-07-08 10:26:16Z

3

No. Convert it to a timestamp first.

answered Jul 8, 2011 at 10:26

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mg. Over a year ago

Or use adapters and converters or, I don't know QT and how it interacts with python types, use the datetime module: docs.python.org/library/…

NotCamelCase Over a year ago

I tried storing it as timestamp but it also did not work but that link will solve it, i guess, thanks.docs.python.org/library/…

Brian Tompsett - 汤莱恩 · Accepted Answer · 2023-05-11 18:25:38Z

0

I tried many methods and most straightforward is convert it to timestamp, then when retrieve it back convert from timestamp to date and that's best solution because if you store it like string object it will be impossible to do logic operations on your data but with timestamp its simple...

edited May 11, 2023 at 18:25

Brian Tompsett - 汤莱恩

5,92772 gold badges63 silver badges135 bronze badges

answered May 11, 2023 at 16:57

Ahmed ElMatbouly

1

Collectives™ on Stack Overflow

Storing python dates in sqlite3

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related