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.go...@ingenia-soluciones.com>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.go...@ingenia-soluciones.com <r.sanc...@ingenia-soluciones.com> > > > > [image: Descripción: cid:image002.jpg@01CB8CB6.ADEBA830] > > 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.dais...@butterflysystems.co.uk
