Re: [sqlite] translate time comparison statement

2006-01-11 Thread Dennis Cote
[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');

Re: [sqlite] translate time comparison statement

2006-01-11 Thread Dennis Cote
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',

Re: [sqlite] translate time comparison statement

2006-01-11 Thread drh
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

Re: [sqlite] translate time comparison statement

2006-01-11 Thread Mark Wyszomierski
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 >

Re: [sqlite] translate time comparison statement

2006-01-11 Thread 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

Re: [sqlite] translate time comparison statement

2006-01-11 Thread Dennis Cote
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

[sqlite] translate time comparison statement

2006-01-11 Thread Mark Wyszomierski
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: