Convert seconds into days

Question

I have a very simple question: How to convert seconds into days? tried using:

<?php echo date('d', $userstats['OnlineTime']); ?>

but only goes up to 31 days.

<?php
   $userstats_a = mysql_query("SELECT * FROM user_stats INNER JOIN users ON user_stats.id = users.id WHERE users.Rank <5 ORDER BY user_stats.OnlineTime DESC LIMIT 5");

   while($userstats = mysql_fetch_assoc($userstats_a)){
   ...

Answer 1

A day has 86400 seconds ( 60 * 60 * 24 ).

To convert seconds into days:

$dias = $segundos / 86400;

If you don’t want decimals, round down:

$dias = floor( $segundos / 86400 );

rounding up:

$dias = ceil( $segundos / 86400 );

Manual of the main rounding functions:

http://php.net/manual/en/function.floor.php

http://php.net/manual/en/function.ceil.php

http://php.net/manual/en/function.round.php

Answer 2

You can do an operation on your own SELECT:

SELECT OnlineTime / 60 / 24 AS Tempo FROM user_stats INNER JOIN users ON user_stats.id = users.id WHERE users.Rank <5 ORDER BY user_stats.OnlineTime DESC LIMIT 5 

Answer 3

You can get the expected result using the class Datetime, take the example:

We created a function to facilitate use:

function converterSegundos($segundos, $formato) {
    $dtF = new \DateTime('@0');
    $dtT = new \DateTime("@$segundos");
    return $dtF->diff($dtT)->format($formato);
}

Now to use simply call the function informing a format, below returns in seconds.

// 6 segundos
echo converterSegundos(6, '%s segundos');

Now only minutes:

// 6 minutos
echo converterSegundos(369, '%i minutos');

You can return the time:

// 10 horas
echo converterSegundos(36000, '%h horas');

You can return the days:

// 60 dias
echo converterSegundos(5184000, '%a dias');

Or

// 60 dias, 0 horas, 0 minutos e 0 segundos
echo converterSegundos(5184000, '%a dias, %h horas, %i minutos e %s segundos');

See working on repl it.

Reference

• Datetime