Re: [請益] 將mySQL的time資料型態轉為數字

[PHP5 (Powered by Zend Engine2)]

※ 引述《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
→ dinos:why not TIME_TO_SEC(time expr)