Hi.
I meant the system environment variable. I do not really believe that
it causes the problem, because it shouldn't be able to shift by a
whole day. But this is the only thing I know of which may influence
time values. On second thought, I really think it isn't TZ, because
that influences only
lf Of Benjamin
Pflugmann
Sent: Tuesday, May 28, 2002 6:19 PM
To: Kevin Carlson
Cc: Mysql
Subject: Re: Interesting datetime problem
Hi.
Maybe your TZ (timezone) environment variable is set to a strange
value? If not, could you provide a full example, so that we can try to
reproduce it and see wh
Hi.
Maybe your TZ (timezone) environment variable is set to a strange
value? If not, could you provide a full example, so that we can try to
reproduce it and see whether this is a local behaviour of your machine
or a common MySQL behaviour.
Bye,
Benjamin.
On Tue, May 28, 2002 at 01:27
Hi,
I have an interesting problem when updating columns of type DATETIME. It
seems that exactly one day is subtracted from the DATETIME value that I
submit in an update query. Has anyone encountered this? Any ideas?
Kevin
-