RE: Changing the timezone

2011-02-24 Thread Travis Ard
set time_zone='Europe/Kiev';

-Original Message-
From: Andre Polykanine [mailto:an...@oire.org] 
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='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!
  

-- 
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=travis_...@hotmail.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Changing the timezone

2011-02-24 Thread Andre Polykanine
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='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!
  

-- 
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=arch...@jab.org