[DRILL-4617] dayofmonth() function returns incorrect result for date type

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 18/Apr/16 22:07
• Updated: 18/Apr/16 22:07

Description

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

---------