From: Date: January 28 2004 7:10am
Subject: RE: Select older than minutes
List-Archive: http://lists.mysql.com/mysql/158514
Message-Id: <20040128061052.MDXH19895.lakemtao04.cox.net@home62bw71d49z>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

SELECT * FROM `support_start` WHERE (NOW() - (60*7)) > TO_DAYS(date)

Not the most optimized way of doing it, but it would work.  60 seconds in a
minute and 7 minutes is the example.

Donny

> -----Original Message-----
> From: Scott Haneda [mailto:lists@stripped]
> Sent: Wednesday, January 28, 2004 12:01 AM
> To: MySql
> Subject: Select older than minutes
> 
> 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
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=donny@stripped