B.4.3.7 Time Zone Problems
If you have a problem with
SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. The same applies if
UNIX_TIMESTAMP() returns the wrong value. This should be done for the environment in which the server runs (for example, in mysqld_safe or mysql.server). See Section 4.9, “Environment Variables”.
The permissible values for
TZ are system dependent. Consult your operating system documentation to see what values are acceptable.