2 Replies Latest reply on Apr 4, 2017 1:50 PM by chris.engstrom

    Given sysuptime in seconds, how are you doing date math to display days/hours/mins/seconds?

    chris.engstrom

      I was hoping to do the following:

       

      SELECT top 10 NodeID, IPAddress, DNS, LastBoot, (SystemUpTime / 86400) as Days, ((SystemUpTime / 3600 ) % 24) as Hours, ((SystemUpTime / 60 ) % 60) as Mins, (SystemUpTime % 60) as Secs

      FROM Orion.Nodes

       

      I get the error:

      The data types real and int are incompatible in the modulo operator.

       

      Suggestions?

       

      Thanks