Hello
I want change time format for Total Flight Hours in my website , 25.49 -> 25:49:00 (HH:MM:SS)
I try to sum flighttime_stamp in pireps table :
$params = array(
'table' => TABLE_PREFIX.'pireps',
'fields' => 'SUM(`flighttime_stamp`) AS `total`',
'where' => array('accepted' => PIREP_ACCEPTED),
);
$sql = DB::build_select($params);
$results = DB::get_results($sql);
echo $total = $results[0]->total;
That code shown Total Flight Hours 20:30:12 (HH:MM:SS) but my VA Total Flight Hours is 25.49 .
I don't understand why !!
Tnx