------=_NextPart_000_0139_01CA4E3B.20A5E360
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I need to change the computer clock (changing the /etc/zoneinfo) but I would
not restart de MySQL service. The NOW() still returning the old time...
Thanks,
Jonas
------=_NextPart_000_0139_01CA4E3B.20A5E360--
Jonas,
your information is somewhat incomplete, but still:
Jonas Silveira wrote:
> Hi,
>=20
> =20
>=20
> I need to change the computer clock (changing the /etc/zoneinfo) bu=
t I would
=46rom the file name, I assume it is some Unix platform.
> not restart de MySQL service. The NOW() still returning the old tim=
e...
"Works as designed":
A process inherits time zone information when it starts, from the par=
ent
and the then valid environment.
This also holds for the MySQL server.
That is why time zone information contains the info about when daylig=
ht
saving time starts / ends:
A process starting before the change and still running after that wil=
l
use the correct time only because it got the information (about the
change point) already when it started.
HTH,
Jörg
--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
(+49 30) 417 01 487
Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB1610=
28
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg