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

Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2017/06/12 21:05:00 UTC

[jira] [Created] (DRILL-5580) Casting DateTime types to Numeric types should be supported

Abhishek Girish created DRILL-5580:
--------------------------------------

             Summary: Casting DateTime types to Numeric types should be supported
                 Key: DRILL-5580
                 URL: https://issues.apache.org/jira/browse/DRILL-5580
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types, Query Planning & Optimization
    Affects Versions: 1.11.0
            Reporter: Abhishek Girish
            Assignee: Chunhui Shi


Currently we can cast numeric types such as Int / BigInt to Date / Time / Timestamp. 

Example
{code}
Int 1 to Date: 1970-01-01
Int 1 to Time: 00:00:00.001
Int 1 to Timestamp: 1970-01-01 00:00:00.001
{code}

Casting Date / Time / Timestamp to Int / BigInt should also be supported, as they are internally stored as BigInt. Currently we get a NumberFormatException for explicit casts on these types. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)