Krystal created DRILL-4617:
------------------------------
Summary: dayofmont() function returns incorrect result for date
type
Key: DRILL-4617
URL: https://issues.apache.org/jira/browse/DRILL-4617
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Krystal
git.commit.id=e4725ea53dce58499974be93b3da87388e7df51c
For character type, the dayofmonth function returns correct data:
select dayofmonth(cast('2016-04-09' as varchar(10))) from test_tbl limit 1;
+---------+
| EXPR$0 |
+---------+
| 9 |
+---------+
For date type, the dayofmonth function returns incorrect data:
select dayofmonth(cast('2016-04-09' as date)) from test_tbl limit 1;
+---------+
| EXPR$0 |
+---------+
| 8 |
+---------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
