-
Type:
Story
-
Status: Done
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: Search Services 2.0
-
Labels:None
-
Epic Link:
-
Sprint:Team Ninja-King - S&I 40, Team Ninja-King - S&I 41
-
Release Train:Southall
-
Delivery Team:Search
-
Story Points:13
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
- causes
-
- Review