Date: Tue, 19 Oct 1999 05:34:49 -0500 (CDT) From: Don Read <dread@calcasieu.com> To: Mike Bartlett <cataract@eye2eye.net> Cc: "freebsd-questions@freebsd.org" <freebsd-questions@FreeBSD.ORG> Subject: RE: TZ problem with MYSQL Message-ID: <XFMail.991019053449.dread@calcasieu.com> In-Reply-To: <1145CD545D54D211BCEB0060B067AD0614776E@RETINA>
next in thread | previous in thread | raw e-mail | index | archive | help
On 19-Oct-99 Mike Bartlett wrote: > Hi all, > I'm having a problem right now with mysql as you will see in the paste > below (should explain everything) > mysql> select now() > -> ; > +---------------------+ >| now() | > +---------------------+ >| 1999-10-19 09:07:57 | > +---------------------+ > 1 row in set (0.00 sec) > > bash-2.03# date > Tue Oct 19 11:11:18 SAST 1999 > > The below paste is from the MYSQL manual. > If you have a problem with SELECT NOW() returning values in GMT and not > your local time, you have to set the TZ environment variable to your > current timezone. This should be done for the environment in which the > server runs, for example in safe_mysqld or mysql.server. > > I've added TZ=SAST export SAST to my mysql.server. I've also put those > two lines in my mysql.sh in rc.d, but they seem to be having no effect. > Any idea what the problem may be here? add in /usr/local/etc/rc.d/mysqld.sh : TZ="CDT6CST"; export TZ Regards, --- Don Read dread@calcasieu.com EDP Manager dread@texas.net Calcasieu Lumber Co. Austin TX -- Y2K is not a problem, W2K however ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?XFMail.991019053449.dread>