Re: Select older than minutes

on 01/28/2004 12:03 AM, Duncan Hill at [EMAIL PROTECTED] wrote: > 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 >>

Re: Select older than minutes

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 > and can not seem

RE: Select older than minutes

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:[EMAIL PROTECTED] > Sent: Wednesday, January 28, 2