[IMPALA-5317] add DATE_TRUNC() function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 2.11.0
• Component/s: Frontend
• Labels: built-in-function newbie sql-language
• Assignee: Greg Rahn
• Reporter: Greg Rahn
• Created: 12/May/17 17:41
• Updated: 21/Nov/18 17:16
• Resolved: 07/Sep/17 05:37

Description

date_trunc('field', timestamp) timestamp

Valid values for field are:

• nanoseconds
• microseconds
• milliseconds
• second
• minute
• hour
• day
• week
• month
• quarter
• year
• decade
• century
• millennium

References:

• https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Date-Time/DATE_TRUNC.htm
• https://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

Issue Links

• relates to: IMPALA-5607 Add additional units to EXTRACT, DATE_PART, TRUNC for temporal data types