Current Time Stamp Change

[ellechim]

Hi,

Need your help regarding this. I would like to change the current date ( now() ) of my MySQL. I tried:

SET TIMESTAMP=unix_timestamp('2010-10-01 12:34:56');

but it does not work. Please need your help.

Thank you.

[PhilipToop]

It is my understand that now() is the current time of the computer on which mysql is running so the solution would be to change the time of he computer.

Timestamp is a data type.

Edit.................

Sorry, should have looked at the documentation first, you are right timestamp is a variable that can be set.