How do I change the mysql server date using SQL

I need to change the server date via sql.

Preferably through my application (CL is also good).

How do I change the mysql server date using SQL?

Why: We test a scenario that spans several weeks. To test it we need to advan开发者_运维百科ce the server date by that time.

---

Do you want to change the server date or the server timezone?

If it is the server date, you have to do it at the OS level.

If it is the time zone, you can change it globally for entire database instance or for your session/connection only.

---

The SET TIMESTAMP statement affects the value returned by NOW() but not by SYSDATE()