You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/24 17:31:00 UTC
[jira] [Updated] (IMPALA-5607) Add additional units to EXTRACT,
DATE_PART, TRUNC for temporal data types
[ 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org