Forum : How can I set the time zone for MySQL to UK time
Brief description  about Online courses   join in Online courses
View Sheetal  Panday 's Profile

How can I set the time zone for MySQL to UK time

Hi,
How can I set the time zone for MySQL to UK time
Asked by Sheetal Panday | Nov 27, 2009 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi sheetal,

If you set the environment variable TZ=GB, then start MySQL the time zone will be set to UK time.

I.E. (Linux only)
bash:#TZ=GB
bash:#export TZ
bash:#mysqld &

You can also set environment variables in my.cnf; In the data (normally var) directory.
Nov 27, 2009