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)

Reply via email to