DelphiFAQ Home Search:

What timezone is my mysql database server running in?


commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.


I use mysql with various options from the command line, so when I look at the process list, I cannot see if the timezone is set and what it is set to. There are too many other arguments.
How can I find out what timezone mysql uses?


You can query the global variable @@system_time as shown in the example below.

# /usr/local/mysql/bin/mysql mysql -e "select distinct @@system_time_zone from user"
| @@system_time_zone |
| UTC                | 

Content-type: text/html




NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: