Re: Date arithmetic?
| From: | Mark Maggelet | Date: | Mon, 13 Nov 2000 23:30:19 +0000 |
| Subject: | Re: Date arithmetic? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-25054@lists.php.net to get a copy of this message | ||
On Mon, 13 Nov 2000 16:58:37 -0500, Colin Kane
(ckane0@alan.coastal.edu) wrote:
>Can i add integer values to date type variables?
>i want something to be valid for a week or so...and then i want it
>to be
>ignored...is there a function or method for doing this?
>Thanks...
>Colin
are you talking about a mysql date type?
if so you could do:
select * from table where to_days(now())-to_days(my_date_field) <= 7;
- Mark