Uploaded image for project: 'Search and Discovery'
  1. Search and Discovery
  2. SEARCH-2353

Support for TIMESTAMPADD(timeUnit, integer, datetime)

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: Search Services 2.0
    • Labels:
      None

      Description

      When trying to create a line graph (continuous) for this data it produces the following error in tableau:

      Because of that the following functions must be tested/implemented:

      TIMESTAMPADD(timeUnit, integer, datetime)	Returns datetime with an interval of (signed) integer timeUnits added. Equivalent to datetime + INTERVAL 'integer' timeUnit
      TIMESTAMPDIFF(timeUnit, datetime, datetime2)	Returns the (signed) number of timeUnit intervals between datetime and datetime2. Equivalent to (datetime2 - datetime) timeUnit
      

      Acceptance criteria:

      • both TIMESTAMPADD and TIMESTAMPDIFF work as SQL standards expect

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  abenedetti Alessandro Benedetti
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel