mysql 格式化datetime,将MySQL号码格式化为datetime？

I have a MySQL database show uptime for devices. The uptime is how long the device has been up in seconds. I have a query showing all devices with uptime less than 86400 (24 hours) which I want to bring into a PHP page.

I want to format this uptime string number into a datetime that's human readable. Here is my query:

select hostname,type,uptime from devices where uptime < 86400

And here is sample output:

hostname: serverA

type: server

uptime: 10329

How can I turn that 10329 into an actual time? I assume there is some sort of value that can pull the current time in seconds, minus that uptime value, and convert that into MM/DD/YYYY HH:MM:SS readable value?

Any help is great appreciated!

EDIT:

Decided to use both answer below, but here is the query that fits my needs:

SELECT hostname AS Server,type AS Type,NOW() - INTERVAL uptime SECOND AS "Boot Time",last_polled AS "Last SNMP Poll" FROM devices WHERE uptime < 86400

Which returns:

Server: ServerA

Type: server

Boot Time: 2014-02-11 13:26:52

Last SNMP Poll: 2014-02-11 18:35:14

解决方案SELECT NOW() - INTERVAL 10329 SECOND