Hi, If you have two datetime fields dta and dtb, a db().select(dta-dtb) will return zero using the sqlite db, but a correct value if you use postgresql for example. The trick to make it work is to replace dta by julianday(dta) in the select, e.g. db().select(julianday(dta)-julianday(dtb)).
I guess not that easy to fix, especially since this substitution would have to operate only when a datetime delta is computed? Or is there a way to do it I havent't found? Andre --
