[jira] [Resolved] (IMPALA-5315) Cast to timestamp fails for YYYY-M-D format

["Vincent Tran (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-5315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vincent Tran resolved IMPALA-5315.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.12.0

> Cast to timestamp fails for YYYY-M-D format
> -------------------------------------------
>
>                 Key: IMPALA-5315
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5315
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.6.0, Impala 2.7.0, Impala 2.8.0
>            Reporter: Greg Rahn
>            Assignee: Vincent Tran
>            Priority: Major
>              Labels: ansi-sql, newbie, sql-language, tpc-ds
>             Fix For: Impala 2.12.0
>
>
> Dates with single digit months or days should cast to valid timestamps. 
> This returns NULL since it fails but should be valid.
> {noformat}
> impala> select cast('2000-3-1' as timestamp);
> +--------------------------------+
> | cast('2000-3-1' as timestamp)  |
> +--------------------------------+
> | NULL                           |
> +--------------------------------+
> {noformat}
> Postgres
> {noformat}
> grahn=# select cast('2000-3-1' as timestamp);
>       timestamp
> ---------------------
>  2000-03-01 00:00:00
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)