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

tdanner

How about this?

SELECT top 10 NodeID, IPAddress, DNS, LastBoot,    DAYDIFF('1970-1-1',AddSecond(SystemUpTime, '1970-1-1')) AS Days,    HOUR(AddSecond(SystemUpTime, '1970-1-1')) AS Hours,    MINUTE(AddSecond(SystemUpTime, '1970-1-1')) AS Mins,    SECOND(AddSecond(SystemUpTime, '1970-1-1')) AS SecsFROM Orion.Nodes