[
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: [email protected]
For additional commands, e-mail: [email protected]