mySQL time incorrect

Question

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

Hi,

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

SYSTEM

score 1 · Answer 1 · answered Sep 27 '09 at 23:29

1

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

answered Sep 27 '09 at 23:29

user21341

score 1 · Accepted Answer · answered Oct 09 '09 at 19:03

1

Restarting mySQL allowed it to use the servers updated timezone

answered Oct 09 '09 at 19:03

2 Answers2