List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:January 28 2004 7:00am
Subject:Select older than minutes
View as plain text  
I have done this so many times..
SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) > 7

I have scoured (more like glanced :-)) at the docs on
<http://www.mysql.com/doc/en/Date_and_time_functions.html> and can not seem
to find how to get all records where a timestamp(14) is older than x
minutes.

Thanks

Thread
MYSQL SecurityTimotius Alfa28 Jan
  • Select older than minutesScott Haneda28 Jan
    • RE: Select older than minutesDonny Simonton28 Jan
    • Re: Select older than minutesDuncan Hill28 Jan
      • Re: Select older than minutesScott Haneda28 Jan
  • Re: MYSQL SecurityMikhail Entaltsev28 Jan
  • Re: MYSQL SecurityVictoria Reznichenko28 Jan
    • Re: MYSQL SecurityTimotius Alfa29 Jan