From: Date: January 28 2004 7:00am
Subject: Select older than minutes
List-Archive: http://lists.mysql.com/mysql/158513
Message-Id: <BC3C9002.17290%lists@newgeo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

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