List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:June 3 2011 10:43am
Subject:Re: timezone
View as plain text  
To take account of daylight savings time in MySQL, load the time zone tables
and set the `default_time_zone` variable to the named time zone for your
country.


On 3 June 2011 11:37, Johan De Meersman <vegivamp@stripped> wrote:

> I would also like to point out, as an aside, that Spain doesn't actually
> have two timezones - it has a single timezone with daylight savings time.
> The real question is, thus, to figure out wether or not you are on DST or
> not.
>
> That, however, I have no idea how to do - the system takes care of it
> automagically. I'm not even sure it gets tracked somewhere on the system,
> you might need to download and parse the rules yourself in your code.
>
> Unless, of course, you're talking about the timezone difference between
> Spain and the Canaries, but you mentioned summer/winter time explicitly, so
> I don't think so.
>
>
> ------------------------------
>
> *From: *"John Daisley" <daisleyjohn@stripped>
> *To: *"Rocio Gomez Escribano" <r.gomez@stripped>
> *Cc: *mysql@stripped
> *Sent: *Friday, 3 June, 2011 12:08:34 PM
> *Subject: *Re: timezone
>
>
> now() returns the current system time which doesn't really have a great
> deal to do with time zones.
>
> You can check what the current time zone is set to with the following
> command
>
> *show variables like 'time_zone';*
>
> but that is likely to return the value '*SYSTEM*' which means it takes the
> value from the host operating system ( usually set in /etc/timezone ).
>
> You can set the time_zone variable either globally or per session to an
> offset of UTC as follows
>
> *SET time_zone='+00:00:00';*
> *SET GLOBAL time_zone='+00:00:00';*
>
> Or you can specify a '*default_time_zone*' in your my.cnf/my.ini options
> file.
>
> You can also set the time_zone variables to a named offset which will then
> take account of daylight savings times but to do this you must first load
> the mysql time zone tables.
>
> I strongly suggest you read the manual section relating to time zone
> support which you can find here
>
> http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html
>
>
>
> On 3 June 2011 10:27, Rocio Gomez Escribano <
> r.gomez@stripped> wrote:
>
>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>



-- 
John Daisley
Butterfly Information Systems

Microsoft SQL Server Database Administrator
Certified MySQL 5 Database Administrator & Developer
Cognos BI Developer \ Administrator

Available for short & long term contracts

Telephone: +44 (0)7918 621621
Email: john.daisley@stripped

Thread
timezoneRocio Gomez Escribano3 Jun
Re: timezoneJohn Daisley3 Jun
  • RE: timezoneRocio Gomez Escribano3 Jun
Re: timezoneJohn Daisley3 Jun
  • Re: timezoneJohan De Meersman3 Jun
    • Re: timezoneJohn Daisley3 Jun
  • RE: timezoneJerry Schwartz3 Jun