- "When the server starts, it attempts to
determine the time zone of the host machine and uses it to set
system_time_zonesystem variable. The value does not change thereafter."
- "You can set the system time zone for MySQL Server at startup
--timezone=option to mysqld_safe. You can also set it by setting the
TZenvironment variable before you start mysqld."
- "The initial global server time zone value can be specified
explicitly at startup with the
--default-time-zone=option on the command line, or you can use the following line in an option file:"
"Per-connection time zones. Each client that connects has its
own time zone setting, given by the session
time_zonevariable. Initially, the session variable takes its value from the global
time_zonevariable, but the client can change its own time zone with this statement:"
SET time_zone =
- "The current values of the global and client-specific time zones can be retrieved like this:"
SELECT @@global.time_zone, @@session.time_zone;
*** READ THIS ***
*** AND THIS ***http://stackoverflow.com/questions/1646171/mysql-datetime-fields-and-daylight-savings-time-how-do-i-reference-the-extra
- "You shouldn't want to store time zone info in database. Store all date/time data as UTC and always make time zone offset adjustment on the application layer. – marekful Nov 7 '13 at 18:00"