I need to INSERT tomorrows date....
| From: | Trond Erling Hundal | Date: | Mon, 09 Oct 2000 10:38:35 +0000 |
| Subject: | I need to INSERT tomorrows date.... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3427@lists.php.net to get a copy of this message | ||
Hey..
I am developing a news portal for a newspaper, and one of the desired
functions here is that the reporters want to be able to put in articels
that will not appear on the web until the day they want it to be "published"
I`ve been experimenting with DATE_ADD(NOW(), INTERVAL 1 DAY) in the INSERT
command, but this only returns a null value in the date field.
I was kind of hoping that I wouldn`t have to do a SELECT DATE_ADD(NOW(),
INTERVAL 1 DAY command , and then insert this result into the INSERT
command...
I wonder what I am doing wrong...
1. Is it possible to insert the DATE_ADD command with MySQL (And I`ve been
having som typos in the command) or
is there some other way of doing this?? Pls help me...