[
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)
