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)
