01.
$sql
="SELECT
02.
IF(TIMESTAMPDIFF(SECOND,time_start,time_end) > 60,
03.
FLOOR
(TIMESTAMPDIFF(SECOND,time_start,time_end)/60)
04.
,
'0'
) ไม่เข้าเงื่อนไขแสดง 0
05.
AS time_error_min,
06.
IF(TIMESTAMPDIFF(SECOND,time_start,time_end) < 60,
07.
TIMESTAMPDIFF(SECOND,time_start,time_end),
08.
TIMESTAMPDIFF(SECOND,time_start,time_end)%60)
09.
AS time_error_sec
10.
11.
$sql
.=
" FROM Table"
;