Re: Select older than minutes

2004-01-28 Thread Scott Haneda
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

2004-01-28 Thread Duncan Hill
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

2004-01-27 Thread Donny Simonton
, 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.co

Select older than minutes

2004-01-27 Thread Scott Haneda
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 to find how to get all records where a timestamp(14) is older th