[
https://issues.apache.org/jira/browse/DRILL-976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14029915#comment-14029915
]
Mehant Baid commented on DRILL-976:
-----------------------------------
Internally we store the time portion of the Interval data type as milliseconds.
Looks like while extracting second we are not pruning the hours, minutes part
before returning.
> Extracting second from an interval value is returning the wrong value
> ---------------------------------------------------------------------
>
> Key: DRILL-976
> URL: https://issues.apache.org/jira/browse/DRILL-976
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Rahul Challapalli
> Assignee: Mehant Baid
> Priority: Minor
>
> The below query returns 9045.1 It should ideally return 45.1
> select extract (second from interval '1 2:30:45.100' day to second) from
> basic limit 1
--
This message was sent by Atlassian JIRA
(v6.2#6252)
