使用PHP减去两个MySQL时间变量

Question

I show my problem:

I have two variables that contain the TIME variable from an MySQL database:

$row[0] //it contains for instance 16:30:00
$row[1] //it contains for instance 18:00:00

How do I find the term that is derived from their subtraction?

As they are already time variables I tried to do a subtraction directly with these values ​​but I get integer values ​​rounded down.

I tried existing questions but none foresaw a time in the format HH: MM: SS.

Thank you.

Answer 1

try to use

$query = select TIMEDIFF(field_name, '$input_date') from tbl_name where condition

at mysql