For instance the uptime of a device is reported in seconds. If I wanted to take the resulting integer value of 120,000 and do a simple division operation on it, how do I do it?
The intention is to get a bit more complicated and convert it to ultimately show hours:minutes:seconds but googling that results in a rabbit hole of SQL queries that are beyond me. For now just knowing how (if its possible) to do simple math operations on variables is enough. I just don't know the syntax and can't find any help on it
If the answer is that I absolutely must use a SQL query, then does anyone have a resource I can go through to get a sufficient enough grasp on this to achieve results quickly?