failed basic arithmetic with Date() objects with sqlite3 backend

[matteo nunziati]

hello,

I'm trying to perform basic arithmetic in a query which involves Date() objects. I've tried this with sqlalchemy 1.0.5 and 1.0.12. My backend is sqlite.

Namely, I'm trying to subtract two dates (stored ad Date()) and I only got year delta as result.

Basically, it seems that only year is involved in computation.

Attached is a small demonstrative code.

[matteo nunziati]

ok got it! quite boring to have to explicitly call julianday, but I understand it's not sqlalchemy fault!

[matteo nunziati]

ok got it! quite boring to have to explicitly call julianday, but I understand it's not sqlalchemy fault!