RE: [PHP-DB] Select where date = curdate() and 2 days ago?
| From: | John W. Holmes | Date: | Thu, 01 May 2003 20:38:20 +0000 |
| Subject: | RE: [PHP-DB] Select where date = curdate() and 2 days ago? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27477@lists.php.net to get a copy of this message | ||
> I have a table where one of the columns has a date time field. I am
rtying
> to build a query that will pull all results between the current date
and
> up to 48 hours (2 days) ago. I have tried various queries using
examples
> like below...
SELECT * FROM calls WHERE event_date_time BETWEEN NOW() - INTERVAL 2 DAY
AND NOW()
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/