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)