Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Bob Bedford
April 6, 2005, 4:50 pm
rate this thread
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 ?