Im afraid I dont 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) Thats correct, in Spain its that time. So, mysql is using the timezone correctly, isnt it? Thanks! Rocío Gómez Escribano <mailto:[email protected]> [email protected] Descripción: cid:[email protected] 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:[email protected]] Enviado el: viernes, 03 de junio de 2011 11:18 Para: Rocio Gomez Escribano CC: [email protected] 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 <[email protected]> wrote: Hello! Im having trouble with timezones. Im in Spain, we have 2 different timezone now we are in GMT+2, in winter, this is the GMT+1. Im 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 [email protected] <mailto:[email protected]> ¡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: [email protected]
