[IMPALA-3381] Impala to support AM/PM format in unix_timestamp and from_unixtime

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.5.0
• Fix Version/s: Not Applicable
• Component/s: Backend
• Labels: built-in-function
• Target Version: Product Backlog
• Assignee: Gabor Kaszab
• Reporter: Yibing Shi
• Created: 20/Apr/16 00:55
• Updated: 13/May/19 06:47
• Resolved: 13/May/19 06:47

Description

Need a way to support below format in unix_timestamp, and from_unixtime if possible:

20151214 05:15:00.1234 AM
20151214 05:15:00.1234 PM

An example:

unix_timestamp('20151214 05:15:00.1234 PM', 'yyyyMMdd HH:mm:ss.SSS PP') 

Of course we can choose a different format, only if we can interpret the AM/PM part of a date time string.

The function need to support up to nanosecond

Issue Links

• duplicates: IMPALA-4018 Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT <template>)
• is related to: IMPALA-5237 from_unixtime cannot include literal H - incompatible with hive
• is related to: IMPALA-4018 Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT <template>)