Jonas,
your information is somewhat incomplete, but still:
Jonas Silveira wrote:
> Hi,
>
>
>
> I need to change the computer clock (changing the /etc/zoneinfo) but I would
From the file name, I assume it is some Unix platform.
> not restart de MySQL service. The NOW() still returning the old time...
"Works as designed":
A process inherits time zone information when it starts, from the parent
and the then valid environment.
This also holds for the MySQL server.
That is why time zone information contains the info about when daylight
saving time starts / ends:
A process starting before the change and still running after that will
use the correct time only because it got the information (about the
change point) already when it started.
HTH,
Jörg
--
Joerg Bruehe, MySQL Build Team, joerg.bru...@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: HRB161028
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
