[HIVE-13248] Change date_add/date_sub/to_date functions to return Date type rather than String

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.1.0
• Fix Version/s: 2.1.0
• Component/s: UDF
• Target Version/s: 2.2.0
• Hadoop Flags: Incompatible change
• Release Note: The return type of the DATE_ADD/DATE_SUB/TO_DATE functions has been changed from string to date.
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 09/Mar/16 20:30
• Updated: 27/Feb/24 22:23
• Resolved: 03/Jun/16 18:08

Description

Some of the original "date" related functions return string values rather than Date values, because they were created before the Date type existed in Hive. We can try to change these to return Date in the 2.x line.

Date values should be implicitly convertible to String.

Issue Links

• links to: https://reviews.apache.org/r/47792/