作者PHP5 (Powered by Zend Engine2)
看板PHP
标题Re: [请益] 将mySQL的time资料型态转为数字
时间Tue Oct 30 11:10:54 2007
※ 引述《divaka (猪肉脚)》之铭言：
: 请教版上的高手
: 现在假设我 mySQL 中存了 time 型态的资料
: ex.00:03:30
: 但我希望能在 PHP 中得到总秒数 ex.210秒 (型态为数字)
: 我该如何做呢?
: 感谢 !!!
刚好我这边有现成的 :p
<?php
$hour = $minute = $second = 0;
$time_arr = explode(':', "00:03:30");
$time_arr = array_reverse($time_arr);
if (isset($time_arr[0])) $second = $time_arr[0];
if (isset($time_arr[1])) $minute = $time_arr[1];
if (isset($time_arr[2])) $hour = $time_arr[2];
$sec = ($hour * 60 + $minute) * 60 + $second;
echo "$hour:$minute:$second => $sec \n";
?>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.112.245.58
1F：→ dinos:why not TIME_TO_SEC(time expr) 10/30 11:30