mysql timezone

[Adi Eyal]

Hi all

does anyone out there know how to change the timezone in mysql? Its
running at GMT and should be running at GMT+2.

Its is running on  FreeBSD. 

when I type date from the command line and
 
 Mon Oct 18 17:31:12 SAST 1999
 
 here is what happens when I type select now(); from mysql
 
 mysql> select now();
 +---------------------+
 | now()               |
 +---------------------+
 | 1999-10-18 15:31:37 |
 +---------------------+
 1 row in set (0.00 sec)

the manual talks about setting a TZ environment variable but doesn't
elaborate to any great extent.


Adi