Mark Wyszomierski wrote:
You may want WHERE julianday(date('now')) - julianday(date(arrival_date)) > 7
Mark,You should still use the 'localtime' modifier on the 'now' value if your timestamps are local time since 'now' always returns UTC times.
WHERE julianday(date('now', 'localtime')) - julianday(date(arrival_date)) > 7 Dennis Cote