| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Scott Haneda | Date: | January 28 2004 7:00am |
| Subject: | Select older than minutes | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • MYSQL Security | Timotius Alfa | 28 Jan |
| • Select older than minutes | Scott Haneda | 28 Jan |
| • RE: Select older than minutes | Donny Simonton | 28 Jan |
| • Re: Select older than minutes | Duncan Hill | 28 Jan |
| • Re: Select older than minutes | Scott Haneda | 28 Jan |
| • Re: MYSQL Security | Mikhail Entaltsev | 28 Jan |
| • Re: MYSQL Security | Victoria Reznichenko | 28 Jan |
| • Re: MYSQL Security | Timotius Alfa | 29 Jan |
