[SQL] Update/Insert datetime problem

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. :slight_smile: