DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

What timezone is my mysql database server running in?

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

Generated 0:00:38 on Oct 17, 2019