[HIVE-6046] add UDF for converting date time from one presentation to another

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.0
• Component/s: UDF
• Assignee: Kostiantyn Kudriavtsev Assign to me
• Reporter: Kostiantyn Kudriavtsev
• Created: 17/Dec/13 20:29
• Updated: 08/Feb/17 05:32
• Resolved: 08/Feb/17 05:32

Description

it'd be nice to have function for converting datetime to different formats, for example:
format_date('2013-12-12 00:00:00.0', 'yyyy-MM-dd HH:mm:ss.S', 'yyyy/MM/dd')
There are two signatures to facilitate further using:
format_date(datetime, fromFormat, toFormat)
format_date(timestamp, toFormat)

Issue Links

• is duplicated by: HIVE-6214 Need a UDF to convert a Date String from any standard format to another. Should be able to provide the Date String, current format and to the format into which it need to be converted and returned as String output of UDF
• relates to: HIVE-10276 Implement date_format(timestamp, fmt) UDF
• links to: https://reviews.apache.org/r/18143/