Difference between two timestamp in hh:mm:ss format

Question

I have two timestamp like below format in my database.

$time1 = 4/19/2019 12:21:01 AM
$time2 = 4/19/2019 12:22:50 AM

I want get difference between this two timestamp like

12:21:01

Let me know if someone can give me idea/solution for do it using php.

there is no *one* difference. the second value has no date, so your difference could be any multiple of one day. unless you *assume* a date, what you want to achieve has no actual value. *if* you assume a date, just convert it to DateTime-objects and substract them. — Franz Gleichmann, Apr 25 '19 at 18:00
I think You understood it wrong, Let me edit my question. Thanks — Raju Bhatt, Apr 25 '19 at 18:02
@FranzGleichmann he has added the sample of timestamp and then he needs the output like the other. — Asif, Apr 25 '19 at 18:03

score 2 · Accepted Answer · answered Apr 25 '19 at 18:06

You can get the difference as

$time1 = '4/19/2019 12:21:01 AM';
$time2 = '4/19/2019 8:15:01 PM';

$start    = new DateTime($time1); 
$end      = new DateTime($time2); 
$diff     = $start->diff($end); 
print $diff->format("%H:%I:%S");

For more details PHP Manual

Asif · Answer 2 · 2019-04-25T18:12:19.067

2

So you should have mysql select query like this:

Select time1,time2,time_format(abs(timediff(time1,time2)), "%H:%i") as diff From table1

You can change time format, follow this link for time_format function

edited Apr 25 '19 at 18:12

answered Apr 25 '19 at 18:08

Asif

350
2
10

This is using SQL whereas the question is about PHP. – Nigel Ren Apr 25 '19 at 18:11
He has mentioned that i have two timestamps in Database and i need difference. – Asif Apr 25 '19 at 18:13
Thanks for answer. Can You please give me solution for PHP instead of SQL query? Thanks – Raju Bhatt Apr 25 '19 at 18:20
Have you tried the above answer by @Rakesh? – Asif Apr 25 '19 at 18:22

Difference between two timestamp in hh:mm:ss format

2 Answers2