Date and a few days query help...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux