----- Original Message ----- From: "John W. Holmes" <holmes072000@charter.net> To: "'Lewis Watson'" <lists@visionsix.com>; <php-db@lists.php.net> Sent: Thursday, May 01, 2003 3:38 PM Subject: RE: Select where date = curdate() and 2 days ago? > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
