Mysql DATE_ADD

[Bob Bedford]

Hi, I'm trying this query:

insert into logpay(datetime,ip,typepay,idannounce)
values(DATE_ADD(NOW(),INTERVAL 14 DAYS),'255.255.255.255',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 ?

bob

[Bob Bedford]

Found.

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

It's 14 DAY not DAYS... (without S).