Re: Selecting all records between a date range
| From: | Per Jessen | Date: | Thu, 02 Oct 2008 16:39:09 +0000 |
| Subject: | Re: Selecting all records between a date range | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-281386@lists.php.net to get a copy of this message | ||
Jason Pruim wrote:
> Hi Everyone,
>
> I am working on a app where I need to be able to select all the values
> from a database where the 'timein' field is between a certain date
> range... Essentially the last 7 days...
>
SELECT * FROM timeStore WHERE timein>DATE_SUB(now(),INTERVAL 7 DAYS)
/Per Jessen, Zürich