You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/06/12 23:55:01 UTC

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

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)