Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5607

Add additional units to EXTRACT, DATE_PART, TRUNC for temporal data types

    XMLWordPrintableJSON

Details

    Description

      For EXTRACT, DATE_PART, add:

      • week
      • dow (day of week)
      • doy (day of year)
      • seconds (to complment second)
      • microsecond / microseconds
      • nanosecond / nanoseconds

      For TRUNC add:

      • SS (seconds)

      For less than seconds truncation, use DATE_TRUNC() IMPALA-5317 since there is no standard for abbrievations less than SS (seconds) per Vertica

      References:

      Attachments

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              Unassigned Unassigned
              grahn Greg Rahn
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated: