Changing the timezone

Hi everyone,
since I'm using the shared hosting, I can't change the default
timezone for MySql.
Question is: is there any query that I could launch in my connect.php
before other queries to make my timezone change?
For instance, I make a
mysql_query("SET CHARACTER_SET_DATABASE=3D'utf8'") or die ("Unable to chang=
e database charset: ".mysql_error());
and a
mysql_query("SET NAMES 'utf8'") or die ("Unable to set names: ".mysql_error=
());

Maybe is there a way to change my timezone to Europe/Kiev?
Thank you!
=20

--=20
With best regards from Ukraine,
Andre
Skype: Francophile
Twitter: http://twitter.com/m_elensule
Facebook: http://facebook.com/menelion


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Changing the timezone

set time_zone=3D'Europe/Kiev';

-----Original Message-----
From: Andre Polykanine [mailto:andre@oire.org]=20
Sent: Thursday, February 24, 2011 10:23 AM
To: mysql@lists.mysql.com
Subject: Changing the timezone

Hi everyone,
since I'm using the shared hosting, I can't change the default
timezone for MySql.
Question is: is there any query that I could launch in my connect.php
before other queries to make my timezone change?
For instance, I make a
mysql_query("SET CHARACTER_SET_DATABASE=3D'utf8'") or die ("Unable to =
change database charset: ".mysql_error());
and a
mysql_query("SET NAMES 'utf8'") or die ("Unable to set names: =
".mysql_error());

Maybe is there a way to change my timezone to Europe/Kiev?
Thank you!
=20

--=20
With best regards from Ukraine,
Andre
Skype: Francophile
Twitter: http://twitter.com/m_elensule
Facebook: http://facebook.com/menelion


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dtravis_ard@hotmail.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg