PHP find difference between two datetimes

Question

I m trying to get the difference between two datetimes and return it as a datetime  I ve found examples using diff but I can t seem to get it right    timein   date  Y-m-d H i s     timeout   date  Y-m-d 20 00 00     totaltime    timein- gt diff  timeout     However  totaltime logs 0000-00-00 00 00 00 to my DB  Is this because I m not formatting my totaltime variable

User · Answer

You can simply use datetime diff and format for calculating difference.

<?php
$datetime1 = new DateTime('2009-10-11 12:12:00');
$datetime2 = new DateTime('2009-10-13 10:12:00');
$interval = $datetime1->diff($datetime2);
echo $interval->format('%Y-%m-%d %H:%i:%s');
?>

For more information OF DATETIME format, refer: here
You can change the interval format in the way,you want.

Here is the working example

P.S. These features( diff() and format()) work with >=PHP 5.3.0 only

User · Answer

I m not sure what format you re looking for in your difference but here s how to do it using DateTime   datetime1   new DateTime     datetime2   new DateTime  2011-01-03 17 13 00     interval    datetime1- gt diff  datetime2    elapsed    interval- gt format   y years  m months  a days  h hours  i minutes  s seconds    echo  elapsed

User · Answer

Here is my full post with topic  PHP find difference between two datetimes  USAGE EXAMPLE       echo timeDifference  2016-05-27 02 00 00    Y-m-d H i s    2017-08-30 00 01 59    Y-m-d H i s   false    a days  h hours         459 days 22 hours  string       echo timeDifference  2016-05-27 02 00 00    Y-m-d H i s    2016-05-27 07 00 00    Y-m-d H i s   true   hours  true        -5  int

User · Answer

I collected many topics to make universal function with many outputs  years  months  days  hours  minutes  seconds  with string or parse to int and direction  - if you need to know what side is direction of the difference   Use example          date1  2016-05-27 02 00 00        format  Y-m-d H i s        echo timeDifference  date1   format   2017-08-30 00 01 59    format         1 years 3 months 2 days 22 hours 1 minutes 59 seconds  string       echo timeDifference  date1   format   2017-08-30 00 01 59    format false    a days  h hours         459 days 22 hours  string       echo timeDifference  2016-05-27 00 00 00    format   2017-08-30 00 01 59    format true    d days -   H  I  S   true        -3 days -  00 01 59  string       echo timeDifference  date1   format   2016-05-27 00 05 51    format  false   seconds         9  string       echo timeDifference  date1   format   2016-05-27 07 00 00    format  false   hours         5  string       echo timeDifference  date1   format   2016-05-27 07 00 00    format  true   hours         -5  string       echo timeDifference  date1   format   2016-05-27 07 00 00    format  true   hours  true        -5  int     Function        function timeDifference  date1 pm checked   date1 format  date2   date2 format   plus minus false   return  all    parseInt false                 strtotime1 strtotime  date1 pm checked            strtotime2 strtotime  date2            date1   new DateTime date  date1 format   strtotime1             date2   new DateTime date  date2 format   strtotime2             interval  date1- diff  date2             plus minus  empty  plus minus              strtotime1    strtotime2           -        - no sign before value           switch  return                        case  y               case  year               case  years                    elapsed    interval- format  plus minus   y                    break               case  m               case  month               case  months                    elapsed    interval- format  plus minus   m                    break               case  a               case  day               case  days                    elapsed    interval- format  plus minus   a                    break               case  d                    elapsed    interval- format  plus minus   d                    break               case  h                      case  hour                       case  hours                           elapsed    interval- format  plus minus   h                    break               case  i               case  minute               case  minutes                    elapsed    interval- format  plus minus   i                    break               case  s               case  second               case  seconds                    elapsed    interval- format  plus minus   s                    break               case  all                    parseInt false                   elapsed    plus minus  interval- format   y years  m months  d days  h hours  i minutes  s seconds                    break               default                   parseInt false                   elapsed    plus minus  interval- format  return                      if  parseInt              return  int   elapsed          else             return  elapsed

User · Answer

The code below will show difference for found values only  i e   if years   0  then it will not show years     diffs          years    gt   y        months    gt   m        days    gt   d        hours    gt   h        minutes    gt   i        seconds    gt   s       interval    timeout- gt diff  timein    diffArr       foreach   diffs as  k   gt   v         d    interval- gt format        v       if   d  gt  0             diffArr      d          k               diffStr   implode        diffArr   echo  Difference        diffStr          0     diffStr    PHP EOL

User · Answer

Sorry my previous answer was wrong  If you are trying to take total elapsed time between time and timeout in the format Y-m-d H i s format  take diff between timeout and time in using DateTime object and format it as   y- m- d  H  i  s

User · Answer

John Conde does all the right procedures in his method but doesn t satisfy the final step in your question which is to format the result to your specifications   This code  Demo  will display the raw difference  expose the trouble with trying to immediately format the raw difference  display my preparation steps  and finally present the correctly formatted result    datetime1   new DateTime  2017-04-26 18 13 06     datetime2   new DateTime  2011-01-17 17 13 00        change the millenium to see output difference  diff    datetime1- gt diff  datetime2       this will get you very close  but it will not pad the digits to conform with your expected format echo  Raw Difference     diff- gt format   y years  m months  d days  h hours  i minutes  s seconds     n       Notice the impact when you change  datetime2 s millenium from  1  to  2  echo  Invalid format     diff- gt format   Y- m- d  H  i  s     n       only H does it right   details array intersect key  array  diff array flip   y   m   d   h   i   s       echo   detail array     var export  details   echo   n    array map function  v  k      use  amp  r                 r    k   y  str pad  v 4  0  STR PAD LEFT  str pad  v 2  0  STR PAD LEFT            if  k   y      k   m    r   -            elseif  k   d    r                elseif  k   h      k   i    r               details array keys  details     echo  Valid format     r     now all components of datetime are properly padded   Output   Raw Difference  6 years 3 months 9 days 1 hours 0 minutes 6 seconds Invalid format  06-3-9 01 0 6  detail array  array      y    gt  6     m    gt  3     d    gt  9     h    gt  1     i    gt  0     s    gt  6    Valid format  0006-03-09 01 00 06   Now to explain my datetime value preparation    details takes the diff object and casts it as an array  array flip   y   m   d   h   i   s    creates an array of keys which will be used to remove all irrelevant keys from  array  diff using array intersect key     Then using array map   my method iterates each value and key in  details  pads its left side to the appropriate length with 0 s  and concatenates the  r  result  string with the necessary separators to conform with requested datetime format

[php] PHP find difference between two datetimes

Examples related to php

Examples related to datetime

Examples related to date-math