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

              • Assignee:
                jinchul Jin Chul Kim
                Reporter:
                grahn Greg Rahn
              • Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated: