phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Setting default timezone for Phoenix
Date Sun, 23 Oct 2016 12:45:33 GMT
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

Mime
View raw message