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 "Greg Rahn (JIRA)" <ji...@apache.org> on 2018/11/21 17:17:00 UTC

[jira] [Assigned] (IMPALA-5317) add DATE_TRUNC() function

     [ https://issues.apache.org/jira/browse/IMPALA-5317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Greg Rahn reassigned IMPALA-5317:
---------------------------------

    Assignee: Greg Rahn  (was: sandeep akinapelli)

> add DATE_TRUNC() function
> -------------------------
>
>                 Key: IMPALA-5317
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5317
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Frontend
>            Reporter: Greg Rahn
>            Assignee: Greg Rahn
>            Priority: Major
>              Labels: built-in-function, newbie, sql-language
>             Fix For: Impala 2.11.0
>
>
> 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



--
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