1 Reply Latest reply on Feb 5, 2014 3:09 AM by LadaVarga

    How does the DateTime variable do the calculation of dates that makes it floating like this?

    sgenius

      Hi Everyone,

      Please I like to find out how the DateTime variable does its calculation of dates in such a way that it returns a value as the one highlighted (in blue) in the code below.

      The Relative Time Frame in the Orion Report Writer was set to "Show data over the past 14 hours" and the todays date is February 03, 2014.

       

      SELECT  TOP 10000 Nodes.Caption AS NodeName,
      Interfaces.Caption AS Interface_Caption,
      AVG(InterfaceAvailability.Availability) AS AVERAGE_of_Availability,
      Nodes.Location AS Location

      FROM
      (Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID))  INNER JOIN InterfaceAvailability ON (Interfaces.InterfaceID = InterfaceAvailability.InterfaceID AND Nodes.NodeID = InterfaceAvailability.NodeID)


      WHERE
      ( DateTime BETWEEN 41671.1732407407 AND 41671.7916666667 )
      AND 
      (
        (Interfaces.Caption LIKE '%Tunnel%%')
      )


      GROUP BY Nodes.Caption, Interfaces.Caption, Nodes.Location


      ORDER BY 1 ASC