Re: Date Control Problem
| From: | (Stas Trefilov) | Date: | Sat, 13 Jan 2001 21:30:11 +0000 |
| Subject: | Re: Date Control Problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5879@lists.php.net to get a copy of this message | ||
Hello, "Ian"!
You wrote:
> Case 1:
> Now, I would like to display all data from Test table
> where my due_date is
> before the current date.
due_date LESS THAN now()
> Case 2:
> Same as case 1, I
> would like to display all data from Test table where
> expired_day plus
> posting_date is before the current date.
Try:
posting_date + expired_day < now()
--
Piloteers do it on the road