[IMPALA-5607] Add additional units to EXTRACT, DATE_PART, TRUNC for temporal data types

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Backend
• Labels: built-in built-in-function compatibility incompatibility sql-language
• Target Version: Product Backlog
• Epic Color: ghx-label-2
• Assignee: Unassigned
• Reporter: Greg Rahn
• Created: 30/Jun/17 05:52
• Updated: 21/Dec/20 17:44

Description

For EXTRACT, DATE_PART, add:

• week
• dow (day of week)
• doy (day of year)
• seconds (to complment second)
• microsecond / microseconds
• nanosecond / nanoseconds

For TRUNC add:

• SS (seconds)

For less than seconds truncation, use DATE_TRUNC() IMPALA-5317 since there is no standard for abbrievations less than SS (seconds) per Vertica

References:

• https://www.postgresql.org/docs/current/static/functions-datetime.html
• https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Date-Time/EXTRACT.htm
• https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.1.0/com.ibm.nz.dbu.doc/r_dbuser_functions_expressions_extract_datetime.html
• http://docs.aws.amazon.com/redshift/latest/dg/r_Dateparts_for_datetime_functions.html

Issue Links

• is related to: IMPALA-5317 add DATE_TRUNC() function