[
https://issues.apache.org/jira/browse/DRILL-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krystal updated DRILL-4617:
---------------------------
Summary: dayofmonth() function returns incorrect result for date type
(was: dayofmont() function returns incorrect result for date type)
> dayofmonth() 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)
