[Sqlalchemy-tickets] Issue #3709: failed basic arithmetic with Date() objects with sqlite3 backend (zzzeek/sqlalchemy)

[matteo n. <iss...@bi...>]

New issue 3709: failed basic arithmetic with Date() objects with sqlite3 backend
https://bitbucket.org/zzzeek/sqlalchemy/issues/3709/failed-basic-arithmetic-with-date-objects

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.