PHPFAQ - How can I set the time zone for MySQL to UK time?

Cheapest CO.UK domains in the UK! Ł1.88 per year!
And PHP/MySQL hosting 1p/1c for the first month, NO CATCH!

Question :
How can I set the time zone for MySQL to UK time?

Answer :
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.

Categories Return to Main PHP Faq

PHP & MySQL


Questions
PHP & MySQL
How do I store binary data in mysql?
What is the difference between mysql_connect() and mysql_pconnect()?
When I try to connect to mysql from php I get this error: "Call to unsupported or undefined function mysql_connect();"
How do I limit the number of rows I get out of my database?

Return to the main FAQ list

Free Forum

Design & Layout Copyright Š 2000- 2006 PHP MySQL Web Hosting Comments to Webmaster

Hosted by PHP 4 Hosting - PHP and MySQL Webhosting and Domain Names

Free Forum
Design & Layout Copyright Š 2000- 2006 PHP MySQL Web Hosting	Comments to Webmaster
Hosted by PHP 4 Hosting - PHP and MySQL Webhosting and Domain Names

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

Categories Return to Main PHP Faq

Questions