Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Hi, I'm trying this query:

insert into logpay(datetime,ip,typepay,idannounce)
values(DATE_ADD(NOW(),INTERVAL 14 DAYS),'',2,178)
I want to add 14 days from now in datetime field.

If I use NOW() it works, but using DATE_ADD it doesn't work anymore.

I want the datetime of the mysql server, not the apache server.

It is possible ?


Re: Mysql DATE_ADD

Quoted text here. Click to load it
It's 14 DAY not DAYS... (without S).

Site Timeline