A.4.6. Time Zone Problems
If you have a problem with
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
Appendix F, Environment Variables.
You can set the time zone for the server with the
option to mysqld_safe. You can also set it by
TZ environment variable before
you start mysqld.
The allowable values for
TZ are system-dependent. Consult your
operating system documentation to see what values are