Re: Date and a few days query help...
| From: | Jake Malone | Date: | Fri, 02 May 2003 16:59:53 +0000 |
| Subject: | Re: Date and a few days query help... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27489@lists.php.net to get a copy of this message | ||
what need is the mysql TO_DAYS() function. see below (from the mysql
manual):
SELECT something FROM tbl_name WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <=
2;
The '2' is the number of days you want to go back.
-Jake
"Lewis Watson" <php@visionsix.com> wrote in message
news:003a01c31020$cf4f8980$a977ca41@vsis169...
> 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
>
>