[HIVE-22241] Implement UDF to interpret date/timestamp using its internal representation and Gregorian-Julian hybrid calendar

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.3, 3.2.0, 4.0.0-alpha-1
• Component/s: UDF
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 25/Sep/19 04:15
• Updated: 27/Feb/24 22:24
• Resolved: 28/Sep/19 21:44

Description

UDF that converts a date/timestamp to new proleptic Gregorian calendar (ISO 8601 standard), which is produced by extending the Gregorian calendar backward to dates preceding its official introduction in 1582, assuming that its internal days/milliseconds since epoch is calculated using legacy Gregorian-Julian hybrid calendar, i.e., calendar that supports both the Julian and Gregorian calendar systems with the support of a single discontinuity, which corresponds by default to the Gregorian date when the Gregorian calendar was instituted.

Issue Links

• links to: GitHub Pull Request #789