You could just use the java.util.TimeZone
to get the current timezone. Ashish -----Original Message----- From: Zheng Shao [mailto:zsh...@gmail.com] Sent: Thursday, February 12, 2009 2:31 PM To: hive-dev@hadoop.apache.org; shyam_sar...@yahoo.com Subject: Re: Server time zone ! Not yet. I think JVM take the environment variable TZ for that purpose for all java-related functions. In build-common.xml you should find the following: <env key="TZ" value="US/Pacific"/> This makes sure all current UDFs related to time/date are using the US/Pacific time zone. (Note: all these UDFs are operating on String and Integer types right now) Zheng On Thu, Feb 12, 2009 at 2:21 PM, Shyam Sarkar <shyam_sar...@yahoo.com>wrote: > Is there any 'Server's time zone' implementation inside Hive? For > proper implementation of TIMESTAMP data type, this is necessay to > translate from stored string type. I am focusing on MySQL 6.0 (with > limited properties) for TIMESTAMP. > > http://dev.mysql.com/doc/refman/6.0/en/timestamp.html > > Thanks, > Shyam > > > > -- Yours, Zheng
