At 3:38 AM -0600 3/17/1999, Ruslan Dmitrakovich wrote:
>Hi!
>
>I have some problems with time zone setings.
>When I use date/time function, mysql return result with 2 hour shift. It
>use GTM time zone, but i want to set mysql to my local time zone (GMT+2),
>I don't know how to do this. There is no information in manual about this
>question :(( Please, help me!
Try setting the TZ environment variable in the process that starts up
the mysqld server (e.g., in safe_mysqld or in mysql.server).
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/