[IMPALA-1732] Impala should have more generic functions DATEDIFF(datepart, startdate, enddate), DATEADD(datepart, number, date)

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.1
• Component/s: Frontend
• Labels: newbie sql-language
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Denys Lamanov
• Created: 03/Feb/15 08:45
• Updated: 19/Jun/20 19:48

Description

I guess it should be like implementation in MS SQL:

DATEDIFF(datepart, startdate, enddate)
DATEADD(datepart, number, date)
https://msdn.microsoft.com/en-us/library/ms189794.aspx
https://msdn.microsoft.com/en-us/library/ms186819.aspx