☰

Difference between 2 dates in SQLite Ask Question

tag-icon • tag-icon sqlite
Difference between 2 dates in SQLite Ask Question

How do I get the difference in days between 2 dates in SQLite? I have already tried something like this:

SELECT Date('now') - DateCreated FROM Payment

It returns 0 every time.

ベストアンサー1

 SELECT julianday('now') - julianday(DateCreated) FROM Payment;

おすすめ記事