Re: [sqlite] SELECTing calls < last two weeks?

2008-03-25 Thread Gilles Ganault
On Tue, 25 Mar 2008 11:09:55 -0400, "Derrell Lipman" <[EMAIL PROTECTED]> wrote: >http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Thanks guys. For those interested, here's a way to do it: $sql = "SELECT * FROM calls "; $sql .= "WHERE (julianday('now') - julianday(calls_date)) < 15"; ___

Re: [sqlite] SELECTing calls < last two weeks?

2008-03-25 Thread Griggs, Donald
Regarding: In MySQL, I used the following to only get calls received in the last two weeks: WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY) Is there an equivalent in SQLite, or should I perform this test in PHP? === Hi Giles, The sqlite date/t

Re: [sqlite] SELECTing calls < last two weeks?

2008-03-25 Thread Derrell Lipman
On Tue, Mar 25, 2008 at 11:02 AM, Gilles Ganault <[EMAIL PROTECTED]> wrote: > Hello > > In MySQL, I used the following to only get calls received in the last > two weeks: > > WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY) > > Is there an equivalent in SQLite, or should I perf

[sqlite] SELECTing calls < last two weeks?

2008-03-25 Thread Gilles Ganault
Hello In MySQL, I used the following to only get calls received in the last two weeks: WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY) Is there an equivalent in SQLite, or should I perform this test in PHP? Thank you. ___ sqlite-us