Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

EDIT: I sheepishly fixed this my restarting mysqld. Sorry for wasing people's time


My server's time is set to GMT. When I run "date" in ssh I get

Sun Sep 27 23:36:39 BST 2009

However "CURRENT_TIMESTAMP()" in mySQL returns

2009-09-27 15:36:39

and "SELECT @@global.time_zone" returns


share|improve this question

Is there anything in the error log?

You could have a problem similar to the one in this thread:

081113 15:27:16 [ERROR] Fatal error: Illegal or unknown default time zone

share|improve this answer
up vote 1 down vote accepted

Restarting mySQL allowed it to use the servers updated timezone

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.