[
https://issues.apache.org/jira/browse/DRILL-1140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krystal updated DRILL-1140:
---------------------------
Summary: Casting of a timestamp to time fails (was: Csting of a timestamp
to time fails)
> Casting of a timestamp to time fails
> ------------------------------------
>
> Key: DRILL-1140
> URL: https://issues.apache.org/jira/browse/DRILL-1140
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Krystal
>
> git.commit.id.abbrev=699851b
> 0: jdbc:drill:schema=dfs> select cast(create_time as timestamp) from voter
> where voter_id=1;
> +------------+
> | EXPR$0 |
> +------------+
> | 2014-05-25 03:41:54.0 |
> +------------+
> 0: jdbc:drill:schema=dfs> select cast(create_time as time) from voter where
> voter_id=1;
> message: "Failure while running fragment. < IllegalArgumentException:[
> Invalid format: "2014-05-25 03:41:54" is malformed at "14-05-25 03:41:54" ]"
> The same query from oracle and postgres return the time portion of the
> timestamp.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
