From: Kevin Lewandowski Date: March 27 1999 7:32am Subject: timezone help List-Archive: http://lists.mysql.com/mysql/1076 Message-Id: <11981.990326@hevanet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I want "select now()" to return the time in GMT, although my server is set to PST (-8). Is that possible? I know the documentation says to set the TZ env variable but it doesn't say what format it expects. thanks. Kevin