Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30375 Feature Parity between PostgreSQL and Spark (implementation-dependent behaviours)
  3. SPARK-28623

Support `dow`, `isodow` and `doy` at `extract()`

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

      Currently, we support these field for EXTRACT: YEAR, QUARTER, MONTH, WEEK, DAY, DAYOFWEEK, HOUR, MINUTE, SECOND.

      We also need support: EPOCH, CENTURY, MILLENNIUM, DECADE, MICROSECONDS, MILLISECONDS, DOW, ISODOW, DOY, TIMEZONE, TIMEZONE_M, TIMEZONE_H, JULIAN, ISOYEAR.

      https://www.postgresql.org/docs/11/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT

      Attachments

        Issue Links

          is a clone of

          Sub-task - The sub-task of the issue SPARK-28017 Enhance DATE_TRUNC

          • Major - Major loss of function.
          • Resolved
          is cloned by

          Sub-task - The sub-task of the issue SPARK-28656 Support `millennium`, `century` and `decade` at `extract()`

          • Major - Major loss of function.
          • Resolved
          is related to

          Sub-task - The sub-task of the issue SPARK-23903 Add support for date extract

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #25367

          Activity

            People

              maxgekk Max Gekk
              maxgekk Max Gekk
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: