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 >= curDate()) select curdate() + 36 select * from calls where SUBDATE(CURDATE(), INTERVAL - 2 DAY) SELECT * from calls where event_date_time = 'curdate()' - INTERVAL 1 SECOND I just can't get the syntax right ( or the concept :-) Please help. Thanks. Lewis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
