Re: Finding records within 15 minutes from now?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Are you saying you want all records whose timestamp is less than now plus 15 minutes?

If so...

SELECT ... WHERE ts_col <= CURRENT_TIMESTAMP  + INTERVAL 15 MINUTES;

should do it I'd think.

see here for more (the DATE_ADD function)

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

On Tue, 12 Apr 2005, J J wrote:

I'm struggling with the php or mysql query to find
records within my database that are within 15 minutes
from now and prior.

Example:
It's 2:30pm on 4/12/05

I need to find all records with a RecordTime of 2:45pm
and previous.

So it should find:
rec1 time: 2:45 date: 4/12/05
rec2 time: 2:00 date: 4/12/05
rec3 time: 1:30 date: 4/8/05
etc.

It would not find:
rec4 time: 3:15 date: 4/12/05
rec5 time: 4:00 date: 4/23/05


Make sense?

I'm reviewing the manuals for datediff, curdate and
other functions but nothing seems to be making sense
for what I need.

Any ideas?  Thank you in advance!



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

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


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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux