Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-31415 builtin date-time functions/operations improvement
  3. SPARK-28420

Date/Time Functions: date_part for intervals

    XMLWordPrintableJSON

Details

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

    Description

      Function Return Type Description Example Result
      date_part(text, interval) double precision Get subfield (equivalent to extract); see Section 9.9.1 date_part('month', interval '2 years 3 months') 3

      We can replace it with extract(field from timestamp).

      https://www.postgresql.org/docs/11/functions-datetime.html

      Attachments

        Issue Links

          is cloned by

          Sub-task - The sub-task of the issue SPARK-28690 Date/Time Functions: date_part for timestamps

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

          Web Link GitHub Pull Request #25981

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: