How to insert datetime in sql query

Databases
7

depends on your database system (which OP did not mention)

more robust is to use standard sql date arithmetic –

somedate + INTERVAL 1 MONTH