database,sql,query,table
I noticed that one of my servers had the wrong time set. It's a debian box using 3.23.37. I changed the system time successfully, but the NOW() function is still showing the "old" time. Looking through the docs, I found the SET TIMESTAMP= function and it said that I should use the UNIX timestamp That SHOULD be MMDDhhmmCCYY.ss, but when I execute it, I get an ERROR 1064: syntax near the timestamp that I entered. SET TIMESTAMP='011016302002.00 I've re-started the daemon after changing the system time. What do I do now? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
