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)
