List:General Discussion« Previous MessageNext Message »
From:Rocio Gomez Escribano Date:June 3 2011 9:27am
Subject:RE: timezone
View as plain text  
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

 <mailto:r.sanchez@stripped> r.gomez@stripped

 

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

 <http://www.ingenia-soluciones.com> 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


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