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/time functions are documented at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are virus
free, however the recipient must take full responsibility for virus checking.
This email message is intended for the named recipient only. It may be
privileged and/or confidential. If you are not the named recipient of this
email please notify us immediately and do not copy it or use it for any
purpose, nor disclose its contents to any other person.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
