From: Date: January 28 2004 9:03am
Subject: Re: Select older than minutes
List-Archive: http://lists.mysql.com/mysql/158517
Message-Id: <200401280803.01266.duncanh@icritical.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

On Wednesday 28 January 2004 06:00, Scott Haneda wrote:
> 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.

You haven't said which version of MySQL you're using.

That said:
DATE_SUB.

select * from support_start where time_stamp_field > date_sub(now, interval x 
minute);

Sub for time_stamp_field and x as needed.