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>
>
>
>
> [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
>
>
>
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.daisley@stripped
