PHP - MySQL Substract Different Time

Question

I have a report I built but the problem is the subtract time in the database.

as

$intime= "02:00:00";
$outtime= "03:25:50";

Output will be 01:25:50

So my question is how can I take an action in PHP (string of mysql format time)

Please share if you have tried something ? – Niklesh Raut Jul 16 '16 at 08:58 — Niklesh Raut, Jul 16 '16 at 08:58
Check this : http://stackoverflow.com/a/15688824/2815635 – Niklesh Raut Jul 16 '16 at 08:59 — Niklesh Raut, Jul 16 '16 at 08:59

score 0 · Accepted Answer · answered Jul 16 '16 at 08:58

0

You can do this using PHP's DateTime class:

$a = new DateTime('02:00:00');
$b = new DateTime('03:25:50');
echo $a->diff($b)->format("%H:%I:%S");  // 01:25:50

answered Jul 16 '16 at 08:58

trincot

1 Answers1