CODEWITHSUNDEEP
mysqlsqllinux
pasquers
pasquers

Reputation: 792

CURRENT_TIMESTAMP doesn't match current time on server

SELECT CURRENT_TIMESTAMP

returns the time as 18:00 roughly. However, when running

SELECT @@global.time_zone, @@session.time_zone;

the result is SYSTEM and SYSTEM. Running the 'date' command on my Linux server returns the time as approximately 13:00. How are these two times different?

Upvotes: 1

Views: 1063

Answers (1)

pasquers
pasquers

Reputation: 792

Solution: After changing the timezone on my server, I did not actually restart mysql. I simply reconnected. For anyone curious to restart: 

/etc/init.d/mysqld restart

(u may have to sudo)

Upvotes: 1

Related Questions