[ 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)