[EMAIL PROTECTED] wrote:
Mark Wyszomierski <[EMAIL PROTECTED]> wrote:
SELECT school_name from schools WHERE julianday('now') -
julianday(arrival_date) > 7
Dennis Cote <[EMAIL PROTECTED]> wrote:
SELECT school_name from schools
WHERE date(arrival_date) < date('now', '-7 days');
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',
Mark Wyszomierski <[EMAIL PROTECTED]> wrote:
>
> SELECT school_name from schools WHERE julianday('now') -
> julianday(arrival_date) > 7
>
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> SELECT school_name from schools
> WHERE date(arrival_date) < date('now', '-7 days');
>
> SELECT school_name from
Cool thanks,
Mark
On 1/11/06, Kurt Welgehausen <[EMAIL PROTECTED]> wrote:
>
> 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
>
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
Mark Wyszomierski wrote:
Hi all,
I'm trying to translate some MySQL to sqlite. Ran into a problem with this
time comparison statement. I translated as best I could, it seems to work,
is this alright? (I'm trying to see if any records are more than 7 days old,
based on the value of
Hi all,
I'm trying to translate some MySQL to sqlite. Ran into a problem with this
time comparison statement. I translated as best I could, it seems to work,
is this alright? (I'm trying to see if any records are more than 7 days old,
based on the value of 'arrival_date' field):
Original:
7 matches
Mail list logo