List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:June 3 2011 10:08am
Subject:Re: timezone
View as plain text  
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:

> I’m afraid I don’’t understand you:
>
>
>
>
>
> mysql> select count(*) from mysql.time_zone_name;
>
> +----------+
>
> | count(*) |
>
> +----------+
>
> |        0 |
>
> +----------+
>
> 1 row in set (0.00 sec)
>
>
>
> But, when I execute:
>
>
>
>
>
> mysql> select now();
>
> +---------------------+
>
> | now()               |
>
> +---------------------+
>
> | 2011-06-03 11:28:00 |
>
> +---------------------+
>
> 1 row in set (0.00 sec)
>
>
>
> That’s correct, in Spain it’s that time. So, mysql is using the timezone
> correctly, isn’t it?
>
>
>
> Thanks!
>
>
>
> *Rocío Gómez Escribano*
>
> r.gomez@stripped <r.sanchez@stripped>
>
>
>
> [image: Descripción: cid:image002.jpg@stripped]
>
> Polígono Campollano C/F, nº21T
>
> 02007 Albacete (España)
>
> Tlf:967-504-513  Fax: 967-504-513
>
> www.ingenia-soluciones.com
>
>
>
> *De:* John Daisley [mailto:daisleyjohn@stripped]
> *Enviado el:* viernes, 03 de junio de 2011 11:18
> *Para:* Rocio Gomez Escribano
> *CC:* mysql@stripped
> *Asunto:* Re: timezone
>
>
>
> Have you populated the timezone tables? Run this query if you are not sure.
>
>
>
> *SELECT COUNT(*) FROM mysql.time_zone_name;*
>
>
>
> *If it returns 0 then you need to populate the them as per the
> instructions here
> http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html*
>
>
>
> Default timezone in mysql is set at server startup to SYSTEM, which means
> so long as your system clock is correct the MySQL server should be correct.
>
>
>
>
>
>
>
> On 3 June 2011 09:55, Rocio Gomez Escribano <
> r.gomez@stripped> wrote:
>
> Hello! I’m having trouble with timezones.
>
>
>
> I’m in Spain, we have 2 different timezone now we are in GMT+2, in winter,
> this is the GMT+1.
>
>
>
> I’m looking for an instruction which give me the current timezone, but I
> cant find it! Do you know how can I now it?
>
>
>
> Thanks!
>
>
>
> *Rocío Gómez Escribano*
>
> r.gomez@stripped <r.sanchez@stripped>
>
>
>
> *¡Error! Nombre de archivo no especificado.*
>
> Polígono Campollano C/F, nº21T
>
> 02007 Albacete (España)
>
> Tlf:967-504-513  Fax: 967-504-513
>
> www.ingenia-soluciones.com
>
>
>
>
>
>
> --
> John Daisley
>
> Certified MySQL 5 Database Administrator
> Certified MySQL 5 Developer
> Cognos BI Developer
>
> Telephone: +44 (0)7918 621621
> Email: john.daisley@stripped
>



-- 
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

Attachment: [text/html]
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