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

<pre><code>SELECT Date('now') - DateCreated FROM Payment
</code></pre>

<p>It returns 0 every time.</p>

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