Date: Tue, 19 Oct 1999 11:36:40 +0200 From: Mike Bartlett <cataract@eye2eye.net> To: "'freebsd-questions@freebsd.org'" <freebsd-questions@freebsd.org> Subject: TZ problem with MYSQL Message-ID: <1145CD545D54D211BCEB0060B067AD0614776E@RETINA>
next in thread | raw e-mail | index | archive | help
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? Regards Mike Bartlett 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?1145CD545D54D211BCEB0060B067AD0614776E>