What timezone is my mysql database server running in?

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

What timezone is my mysql database server running in?

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

Question:

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?

Answer:

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 \| +--------------------+

Send a message to
Subject

Comments:

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. Add a picture:


	Search: