Re: how to insert a date to come ?

[Felix Geerinckx]

mathieu wrote:

> I'd like to insert the date of upcoming events in a datetime field.
> Is it possible to use something like :
> INSERT INTO mytable(event,date)
> values('name',DATE_FORMAT(UNIX_TIMESTAMP(NOW())+3600*24*15,'%Y-%m-%d %h:%i:%s'))

INSERT INTO yourtable (event, date) VALUES('name', CURDATE() + INTERVAL 15 DAY);

See http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
for all info on the date and time functions.

--
felix
Please use BBCode to format your messages in this forum.