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:32:04 UTC

[jira] [Created] (IMPALA-5316) add last_day() function

Greg Rahn created IMPALA-5316:
---------------------------------

             Summary: add last_day() function
                 Key: IMPALA-5316
                 URL: https://issues.apache.org/jira/browse/IMPALA-5316
             Project: IMPALA
          Issue Type: New Feature
          Components: Backend, Frontend
            Reporter: Greg Rahn


LAST_DAY(<date>)
Returns the last day of the month in the specified date.
<date> can be DATE or TIMESTAMP

{noformat}
=> select last_day('2017-05-03');
  LAST_DAY
------------
 2017-05-31

=> select now(), last_day(now());
         NOW         |  LAST_DAY
---------------------+------------
 2017-05-01 17:29:03 | 2017-05-31
(1 row)
{noformat}

Reference: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Date-Time/LAST_DAY.htm



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)