[jira] [Commented] (PHOENIX-3220) DAYOFMONTH function not giving correct result for 24hr clock time format

["Ankit Singhal (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-3220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15448929#comment-15448929 ] 

Ankit Singhal commented on PHOENIX-3220:
----------------------------------------

Yes, it's a bug, as during TO_DATE evaluation , date literal is considered in GMT(default) whereas DAYOFMONTH uses a local timezone.

As a workaround until we fix it , you can set phoenix.query.dateFormatTimeZone in the client configuration equal to local timezone.(set explicitly , don't use local keyward) 


Note:- sqlline may not display date properly when you run TO_DATE after the change(because formatter will still use GMT) but you can try using getDate() api .


> DAYOFMONTH function not giving correct result for 24hr clock time format
> ------------------------------------------------------------------------
>
>                 Key: PHOENIX-3220
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3220
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.6.0
>         Environment: CentOS
>            Reporter: Neeru Jaroliya
>
> Query :
> 0: jdbc:phoenix:localhost> select DAYOFMONTH(TO_DATE('2016-04-01 23:45:00'));
> +------------+
> |     2      |
> +------------+
> | 2          |
> +------------+
> Expected Output : 1
> Issue : DAYOFMONTH function on 24hr clock time format increase the result by one.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)