Calculate passed time with PHP

Question

I got the time difference between dates like this :

$time1 = "2013-02-25 12:00:00";
$time2 = "2013-01-01 12:00:00";
$tdiff = strtotime($time1) - strtotime($time2);

I want extract days, hours and minutes from $tdiff. Output should like : 35 days 6 hours 14 minutes

I really searched and try to do something by myself. But I can't get true value.

---- EDIT ---- I can found date diff. I want extract days, hours, minutes from calculated time...

---- EDIT 2 ---- Here is my complete mysql code

select (
    select avg(UNIX_TIMESTAMP(tarih)) from table1 
    where action in (6) and who = '".$user."' and dates between '".$date1."' and '".$date."'
    ) - ( 
    select avg(UNIX_TIMESTAMP(tarih_saat)) from table2 
    where action in (6) and active = 1 and dates between '".$date1."' and '".$date2."
)

This query returns to me true value of time. This query is working correctly for me. Result is like : 215922. result type of UNIX_TIMESTAPM. So I want to learn how many days, hours and minutes in this timestamp.

possible duplicate of [How to calculate the difference between two dates using PHP?](http://stackoverflow.com/questions/676824/how-to-calculate-the-difference-between-two-dates-using-php) — Rikesh, Feb 25 '13 at 09:20
This answer http://stackoverflow.com/questions/7836384/get-remaining-days-hours-and-minutes-using-mysql explains how you could do this in your sql statement (mysql) and links to the manual page on time/date functions without evoking PHP classes. — Cups, Feb 25 '13 at 10:20

Husman · Answer 1 · 2021-02-22T13:40:12.283

10

PHP has a DateInterval class which can be used like so:

$date1 = new DateTime('2013-02-25 12:00:00');
$date2 = new DateTime('2013-01-01 12:00:00');

$diff = $date2->diff($date1); // Get DateInterval Object

echo $diff->format('%d Day and %h hours and %i minutes');

edited Feb 22 '21 at 13:40

answered Feb 25 '13 at 09:20

Husman

6,819
9
29
47

1

`%m` in `format()` is incorrect! The minute should use `%i`. Here is reference ( https://www.php.net/manual/en/dateinterval.format.php ). – vee Apr 04 '19 at 14:14

Pannan Mp · Answer 2 · 2013-02-25T10:05:26.663

-1

you could use date object to get more accurate.
the default var type doesnt give the time difference.
most often they are considered as string types when assinged like you did it

edited Feb 25 '13 at 10:05

answered Feb 25 '13 at 09:24

Pannan Mp

77
10

2

Completely redundant answer – Basic Bridge Feb 25 '13 at 09:27

Calculate passed time with PHP

2 Answers2

Linked