> > > 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... > > Thanks!! I was getting so tired of staring at the same problem for 2 hours > :-) > Lewis DELETE FROM problems WHERE problem BETWEEN NOW() - INTERVAL 2 HOUR AND NOW() ;) ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
