You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Neeru Jaroliya (JIRA)" <ji...@apache.org> on 2016/08/30 10:01:20 UTC

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

Neeru Jaroliya created PHOENIX-3220:
---------------------------------------

             Summary: 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)