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

Support `*` and `/` operators for intervals

    XMLWordPrintableJSON

Details

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

    Description

      Support `*` by numeric, `/` by numeric. See https://www.postgresql.org/docs/12/functions-datetime.html

      Operator Example Result
      * 900 * interval '1 second' interval '00:15:00'
      * 21 * interval '1 day' interval '21 days'
      / interval '1 hour' / double precision '1.5' interval '00:40:00'

      Attachments

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue SPARK-29684 Support divide/multiply for interval types

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

          Web Link GitHub Pull Request #26132

          Web Link GitHub Pull Request #26410

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: