[
https://issues.apache.org/jira/browse/HIVE-16434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15966946#comment-15966946
]
Ashutosh Chauhan commented on HIVE-16434:
-----------------------------------------
Currently, following returns NULL, whereas postgres and sql server (via its
datetime type) can successfully parse these:
{code}
select cast ('2011/01/01' as timestamp);
select cast ('2011.01.01' as timestamp);
select cast ('March 8, 1999' as timestamp);
select cast ('1/8/1999' as timestamp);
select cast ('01/02/03' as timestamp);
select cast ('1999-Jan-08' as timestamp);
select cast ('08-Jan-1999' as timestamp);
select cast ('08-Jan-99' as timestamp);
select cast ('19990108' as timestamp);
select cast ('990108' as timestamp);
select cast ('04 Mar 2013' as timestamp);
select cast('2012-02-03 04:0' as timestamp);
select cast('2012-02-03 04:05' as timestamp);
{code}
> Add support for parsing additional timestamp formats
> ----------------------------------------------------
>
> Key: HIVE-16434
> URL: https://issues.apache.org/jira/browse/HIVE-16434
> Project: Hive
> Issue Type: Bug
> Components: File Formats, Query Planning
> Reporter: Ashutosh Chauhan
>
> Will be useful to handle additional timestamp formats.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
