Setting default timezone for Phoenix

2016-10-23 Thread Mich Talebzadeh
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

Re: Setting default timezone for Phoenix

2016-10-23 Thread Ankit Singhal
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