You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Greg Rahn (JIRA)" <ji...@apache.org> on 2017/05/12 17:42:04 UTC

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

Greg Rahn created IMPALA-5317:
---------------------------------

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


date_trunc('field', timestamp)	timestamp 

Valid values for field are:
* 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
(v6.3.15#6346)