Display MySQL uptime in days

Question

I found this SQL query to display MySQL uptime:

SHOW GLOBAL STATUS LIKE 'Uptime';

But I get the value 2059555.

How I can convert it to days?

Answer 1

On MySQL prompt type this, On the last line we will find Uptime

mysql>\s

Also if needed to write a query. This will give you in hours and minutes

select TIME_FORMAT(SEC_TO_TIME(VARIABLE_VALUE ),'%Hh %im')  as Uptime 
from information_schema.GLOBAL_STATUS 
where VARIABLE_NAME='Uptime'

Note: Above version 5.7 use performance_schema instead of information_schema

Answer 2

You can run SHOW GLOBAL STATUS; to find the value for Uptime, represented in seconds. Divide by 86,400 (60 * 60 * 24) to convert to days.