[jira] [Created] (DRILL-976) Extracting second from an interval value is returning the wrong value

[Rahul Challapalli (JIRA)]

Rahul Challapalli created DRILL-976:
---------------------------------------

             Summary: 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


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)