Jump to content

mysql set time_zone possible values


Greywacke
 Share

Recommended Posts

hi there,unfortunately i cannot find all the possible values for setting this to on a mysql 5.0.91 server... i find no reference to it! the reason why i ask is because timezones are given in various formats and so forth world wide - and i need to set the timezone on the page for the location the site installation is made for. does anybody know where i could get this? in the timezone conversion class, the possible timezones are set in the php documents - but i have no idea what the possible time_zone values for the page scope would be.

Link to comment
Share on other sites

First result on google might felp you out: http://goo.gl/Y9Xq6found this:

I thought this information will helps somebody who are looking for changing mysql timezone. The steps are:1. Download the timezone table structure and data from http://dev.mysql.com/downloads/timezones.html2. Copy and paste the data in your Mysql/data/mysql folder3. Restart your mysql server.4. mysql> SET GLOBAL time_zone = 'America/Toronto';5. mysql> SET SESSION time_zone = 'America/Toronto';6. Check SELECT @ @global.time_zone , @ @session.time_zone ;It should give you the time zone you set just before.
Edited by gar onn
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...