I want to write a insert/update SQL statement
one field is current time, another field is 1 month or 1 sec after the current time… (for example)
I tried to use …
Insert INTO EXAMPLE (time1, time2) VALUES (now(),now()+1);
but failed…
It shows 0000-00-00 00:00:00 in time2 …
Would you solve this problem for me…?
Thanks in advanced.