RE: [PHP] date - previous two weeks
| From: | Don Read | Date: | Thu, 26 Oct 2000 19:19:07 +0000 |
| Subject: | RE: [PHP] date - previous two weeks | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-22190@lists.php.net to get a copy of this message | ||
On 24-Oct-00 Michael Hall wrote:
> I'd like to have PHP construct an SQL query whereby only rows that have a
> date within the previous two weeks are returned. I've tried various things
> but not even got close. Any one got any ideas?
>
MySQL:
select * from da_table where da_date > DATE_SUB(current_date, interval 14 day)
Regards,
--
Don Read dread@texas.net
There are old sailors, and there are foolish
sailors; but damn few old foolish sailors.
---------------------------------------------