Ad Widget

Collapse

Event query for get duration

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fgo.oliver
    Junior Member
    • Dec 2019
    • 6

    #1

    Event query for get duration

    Hello guys,

    I'd like a little help please.

    I have the query below and I need to get also duration off each eventid, but like I'm not DB admin, so cant finish this...

    SELECT
    e.eventid, e.source, e.object, e.objectid, e.clock, e.value
    FROM events e
    WHERE SOURCE = 0 LIMIT 100;
  • fgo.oliver
    Junior Member
    • Dec 2019
    • 6

    #2
    Updating, query I'm using bring this result: Click image for larger version

Name:	screenshot.png
Views:	462
Size:	7.9 KB
ID:	391516

    Attached Files

    Comment

    • fgo.oliver
      Junior Member
      • Dec 2019
      • 6

      #3
      Very good! Is an option sure...
      But, I'm in v3 yet...

      I'm fighting for the update... I bilieve soon I'll have success on

      Comment

      Working...