From: Paul DuBois Date: March 17 1999 12:54pm Subject: Re: question about time zone settings List-Archive: http://lists.mysql.com/mysql/413 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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/