On Oct 2, 2008, at 12:39 PM, Per Jessen wrote:

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)

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
[EMAIL PROTECTED]





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to