[IMPALA-114] Impala needs to support more timestamp formats

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.3, Impala 1.2.3
• Fix Version/s: Impala 1.3
• Assignee: Chris Channing
• Reporter: Nong Li
• Created: 07/Mar/13 01:03
• Updated: 20/Dec/15 00:04
• Resolved: 18/Dec/13 13:16

Description

Impala currently only supports timestamps in the format "YYYY-MM-DD HH:MM:SS.sssssssss". Either just the date or time is allowed but for example, "MM-DD-YYYY" is not supported.

For example:
select UNIX_TIMESTAMP('03-03-2012','dd-MM-yyyy')
Query: select UNIX_TIMESTAMP('03-03-2012','dd-MM-yyyy')
Query finished, fetching results ...
NULL
Returned 1 row(s) in 0.22s