Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9358

Create LAST_DAY UDF

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.1.0
    • UDF
    • None
    • Returns the last day of the month which the date belongs to.

    Description

      LAST_DAY returns the date of the last day of the month that contains date:
      last_day('2015-01-14') = '2015-01-31'
      last_day('2016-02-01') = '2016-02-29'

      last_day function went from oracle http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions072.htm

      Attachments

        1. HIVE-9358.1.patch
          12 kB
          Alexander Pivovarov
        2. HIVE-9358.2.patch
          13 kB
          Alexander Pivovarov

        Activity

          People

            apivovarov Alexander Pivovarov
            apivovarov Alexander Pivovarov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: