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";
___
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
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
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
4 matches
Mail list logo