我需要将秒转换为“小时:分钟:秒”。

例如:“685”转换为“00:11:25”

我怎样才能做到这一点呢?


当前回答

gmdate("H:i:s", no_of_seconds);

如果no_of_seconds大于1天(一天中的秒数),将不会以H:i:s格式给出时间。 它将忽略日值,只给出小时:分钟:秒

例如:

gmdate("H:i:s", 89922); // returns 0:58:42 not (1 Day 0:58:42) or 24:58:42

其他回答

试试这个:

date("H:i:s",-57600 + 685);

从 http://bytes.com/topic/php/answers/3917-seconds-converted-hh-mm-ss

使用DateTime的一个简单方法是:

    $time = 60; //sec.
    $now = time();
    $rep = new DateTime('@'.$now);
    $diff = new DateTime('@'.($now+$time));
    $return = $diff->diff($rep)->format($format);

    //output:  01:04:65

这是一个简单的解决方案,让您能够使用DateTime的格式方法。

仅当秒数小于86400(1天)时使用函数gmdate():

$seconds = 8525;
echo gmdate('H:i:s', $seconds);
# 02:22:05

参见: gmdate()

运行Demo


将秒转换为“脚”格式无限制*:

$seconds = 8525;
$H = floor($seconds / 3600);
$i = ($seconds / 60) % 60;
$s = $seconds % 60;
echo sprintf("%02d:%02d:%02d", $H, $i, $s);
# 02:22:05

参见:floor(), sprintf(),算术运算符

运行Demo


DateTime扩展的示例使用:

$seconds = 8525;
$zero    = new DateTime("@0");
$offset  = new DateTime("@$seconds");
$diff    = $zero->diff($offset);
echo sprintf("%02d:%02d:%02d", $diff->days * 24 + $diff->h, $diff->i, $diff->s);
# 02:22:05

参见:DateTime::__construct(), DateTime::modify(), clone, sprintf ()

运行Demo


MySQL示例的结果范围被限制为TIME数据类型,从-838:59:59到838:59:59:

SELECT SEC_TO_TIME(8525);
# 02:22:05

看:SEC_TO_TIME

运行Demo


PostgreSQL的例子:

SELECT TO_CHAR('8525 second'::interval, 'HH24:MI:SS');
# 02:22:05

运行Demo

<?php
$time=3*3600 + 30*60;


$year=floor($time/(365*24*60*60));
$time-=$year*(365*24*60*60);

$month=floor($time/(30*24*60*60));
$time-=$month*(30*24*60*60);

$day=floor($time/(24*60*60));
$time-=$day*(24*60*60);

$hour=floor($time/(60*60));
$time-=$hour*(60*60);

$minute=floor($time/(60));
$time-=$minute*(60);

$second=floor($time);
$time-=$second;
if($year>0){
    echo $year." year, ";
}
if($month>0){
    echo $month." month, ";
}
if($day>0){
    echo $day." day, ";
}
if($hour>0){
    echo $hour." hour, ";
}
if($minute>0){
    echo $minute." minute, ";
}
if($second>0){
    echo $second." second, ";
}

你可以使用gmdate()函数:

echo gmdate("H:i:s", 685);