Hi Mich, phoenix.query.dateFormatTimeZone is honored by functions which are listed on a page[1] and their description has explicit mention of usage of this property to override timezone from default GMT(For eg:[2]). so you need to wrap other function with such function to convert the timezone like you did in your example.
select CURRENT_DATE(), CONVERT_TZ(CURRENT_DATE()); +---------------------------------+---------------------------------+ | DATE '2016-10-23 12:38:02.434' | DATE '2016-10-23 13:38:02.434' | +---------------------------------+---------------------------------+ | 2016-10-23 12:38:02.434 | 2016-10-23 13:38:02.434 | +---------------------------------+---------------------------------+ I think we will update this property[3] with proper description to avoid such confusion. [1]https://phoenix.apache.org/language/functions.html [2]https://phoenix.apache.org/language/functions.html#to_date [3] https://phoenix.apache.org/tuning.html Regards, Ankit Singhal On Sun, Oct 23, 2016 at 6:15 PM, Mich Talebzadeh <[email protected]> wrote: > Hi, > > My queries in Phoenix pickup GMT timezone as default. > > I need them to default to Europe/London by default > > 0: jdbc:phoenix:rhes564:2181> select CURRENT_DATE(), > CONVERT_TZ(CURRENT_DATE(), 'UTC', 'Europe/London'); > +---------------------------------+---------------------------------+ > | DATE '2016-10-23 12:38:02.434' | DATE '2016-10-23 13:38:02.434' | > +---------------------------------+---------------------------------+ > | 2016-10-23 12:38:02.434 | 2016-10-23 13:38:02.434 | > +---------------------------------+---------------------------------+ > > > I want to set this property in hbase-site.xml. This setting does not seem > to work > > <property> > <name>phoenix.query.dateFormatTimeZone</name> > <value>Europe/London</value> > </property> > > > Thanks > > >
