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