Re: Selecting all records between a date range
| From: | Jason Pruim | Date: | Thu, 02 Oct 2008 17:13:07 +0000 |
| Subject: | Re: Selecting all records between a date range | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-281393@lists.php.net to get a copy of this message | ||
On Oct 2, 2008, at 12:39 PM, Per Jessen wrote:
Jason Pruim wrote:Hmmm... To do that, I'd have to store the date/timestamps in a different format... I'll look into this more, but I think I'd have to rewrite the program to make that work. Thanks for the suggestion though! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com japruim@raoset.comHi 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)