[
https://issues.apache.org/jira/browse/IMPALA-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-5607:
----------------------------------
Target Version: Product Backlog (was: Impala 3.1.0)
> Add additional units to EXTRACT, DATE_PART, TRUNC for temporal data types
> -------------------------------------------------------------------------
>
> Key: IMPALA-5607
> URL: https://issues.apache.org/jira/browse/IMPALA-5607
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend, Frontend
> Reporter: Greg Rahn
> Assignee: Jinchul Kim
> Priority: Major
> Labels: built-in, built-in-function, compatibility,
> incompatibility, sql-language
>
> 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|https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Date-Time/TRUNCDateTime.htm]
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
