ellechim — 2010-10-23T02:14:48-04:00 — #1
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.
philiptoop — 2010-10-24T02:51:58-04:00 — #2
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.
Sorry, should have looked at the documentation first, you are right timestamp is a variable that can be set.