# \[SQL\] Update/Insert datetime problem

**URL:** https://forum.kirupa.com/t/sql-update-insert-datetime-problem/222686
**Category:** programming
**Created:** [April 16, 2007, 5:07am UTC](https://forum.kirupa.com/t/sql-update-insert-datetime-problem/222686 "2007-04-16T05:07:10Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![siuj](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@siuj](https://forum.kirupa.com/u/siuj)
#### Post date: [April 16, 2007, 5:07am UTC](https://forum.kirupa.com/t/sql-update-insert-datetime-problem/222686/1 "2007-04-16T05:07:10Z")

</div>

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. 🙂