Re: [sqlite] translate time comparison statement

[Kurt Welgehausen]

You may want

 WHERE julianday(date('now')) - julianday(date(arrival_date)) > 7

so that time of day isn't part of the comparison; otherwise,
you're correct.

Regards