[DRILL-7926] The " age " function is not working properly.

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.17.0, 1.18.0
• Fix Version/s: 1.20.0
• Component/s: Functions - Drill
• Assignee: James Turton
• Reporter: Александр Глухов
• Created: 13/May/21 12:17
• Updated: 27/Sep/21 08:31
• Resolved: 27/Sep/21 08:31

Description

The " age " function is not working properly.
Playback steps

select extract(year from m. "years") `years`  from (select age('2021-05-13', '2007-07-02') `years") m

Expected result 13.
Actual result 14.