[DRILL-976] Extracting second from an interval value is returning the wrong value

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Rahul Kumar Challapalli
• Created: 12/Jun/14 21:53
• Updated: 16/Apr/15 23:07
• Resolved: 18/Jun/14 04:25

Description

The below query returns 9045.1 It should ideally return 45.100

select extract (second from interval '1 2:30:45.100' day to second) from basic limit 1