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 <mich.talebzadeh@gmail.com> 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