Calculate number of hours between 2 dates in PHP

Question

How do I calculate the difference between two dates in hours   For example   day1 2006-04-12 12 30 00 day2 2006-04-14 11 30 00   In this case the result should be 47 hours

User · Answer

t1   strtotime   2006-04-14 11 30 00      t2   strtotime   2006-04-12 12 30 00      diff    t1 -  t2   hours    diff     60   60

User · Answer

lt         day1    2014-01-26 11 30 00         day1   strtotime  day1         day2    2014-01-26 12 30 00         day2   strtotime  day2        diffHours   round   day2 -  day1    3600       echo  diffHours     gt

User · Answer

day1    2006-04-12 12 30 00   day1   strtotime  day1    day2    2006-04-14 11 30 00   day2   strtotime  day2     diffHours   round   day2 -  day1    3600     I guess strtotime   function accept this date format

User · Answer

diff min     strtotime   day2   - strtotime   day1       60   60   total time     diff min   You can try this one

User · Answer

This function helps you to calculate exact years and months between two given dates   doj1 and  doj  It returns example 4 3 means 4 years and 3 month    lt  php     function cal exp  doj1                 doj1 strtotime  doj1            doj date  m d Y   doj1     till date or any given date           now date  m d Y               b strtotime  b1             echo  c  b1- a2            echo date  Y-m-d H i s   c            year date  Y               chk leap is leapyear  year               year diff 365 25            x explode      doj            y1 explode      now             yy  x 2            mm  x 0            dd  x 1             yy1  y1 2            mm1  y1 0            dd1  y1 1            mn 0           mn1 0           ye 0          if  mm1 gt  mm                         mn  mm1- mm              if  dd1 lt  dd                                 mn  mn-1                             ye  yy1- yy                    else if  mm1 lt  mm                         mn 12- mm                 mn  mn               if  mm  1                                 mn1  mm1-1                              mn   mn1              if  dd1 gt  dd                                 mn  1                              yy  yy 1               ye  yy1- yy                    else                        ye  yy1- yy               ye  ye-1                mn 12-1               if  dd1 gt  dd                                 ye  1                   mn 0                                    to  ye   year and    mn   months           return  ye      mn             return daysDiff  x 2   x 0   x 1              days dateDiff      now  doj   year diff           days exp explode      days           return  years exp  days    number of years exp           gt

User · Answer

In addition to  fyrye s very helpful answer this is an okayish workaround for the mentioned bug  this one   that DatePeriod substracts one hour when entering summertime  but doesn t add one hour when leaving summertime  and thus Europe Berlin s March has its correct 743 hours but October has 744 instead of 745 hours   Counting the hours of a month  or any timespan   considering DST-transitions in both directions function getMonthHours string  year  string  month   DateTimeZone  timezone   int          or whatever start and end  DateTimeInterface objects you like      start   new  DateTimeImmutable  year    -     month    -01 00 00 00    timezone        end   new  DateTimeImmutable  new  DateTimeImmutable  year    -     month    -01 23 59 59    timezone  - gt format  Y-m-t H i s     timezone               count the hours just utilizing  DatePeriod   DateInterval and iterator count  hell yeah       hours   iterator count new  DatePeriod  start  new  DateInterval  PT1H     end                find transitions and check  if there is one that leads to a positive offset        that isn t added by  DatePeriod        this is the workaround for https   bugs php net bug php id 75685      transitions    timezone- gt getTransitions  int  start- gt format  U     int  end- gt format  U         if  2     count  transitions   amp  amp   transitions 0   offset   -  transitions 1   offset    gt  0             hours     round   transitions 0   offset   -  transitions 1   offset    3600                   return  hours      myTimezoneWithDST   new  DateTimeZone  Europe Berlin    var dump getMonthHours  2020    01    myTimezoneWithDST       744 var dump getMonthHours  2020    03    myTimezoneWithDST       743 var dump getMonthHours  2020    10    myTimezoneWithDST       745  finally    myTimezoneWithoutDST   new  DateTimeZone  UTC    var dump getMonthHours  2020    01    myTimezoneWithoutDST       744 var dump getMonthHours  2020    03    myTimezoneWithoutDST       744 var dump getMonthHours  2020    10    myTimezoneWithoutDST       744  P S  If you check a  longer  timespan  which leads to more than those two transitions  my workaround won t touch the counted hours to reduce the potential of funny side effects  In such cases  a more complicated solution must be implemented  One could iterate over all found transitions and compare the current with the last and check if it is one with DST true- gt false

User · Answer

The newer PHP-Versions provide some new classes called DateTime  DateInterval  DateTimeZone and DatePeriod  The cool thing about this classes is  that it considers different timezones  leap years  leap seconds  summertime  etc  And on top of that it s very easy to use  Here s what you want with the help of this objects      Create two new DateTime-objects     date1   new DateTime  2006-04-12T12 30 00     date2   new DateTime  2006-04-14T11 30 00        The diff-methods returns a new DateInterval-object     diff    date2- gt diff  date1       Call the format method on the DateInterval-object echo  diff- gt format   a Day and  h hours      The DateInterval-object  which is returned also provides other methods than format  If you want the result in hours only  you could to something like this    date1   new DateTime  2006-04-12T12 30 00     date2   new DateTime  2006-04-14T11 30 00      diff    date2- gt diff  date1     hours    diff- gt h   hours    hours     diff- gt days 24    echo  hours    And here are the links for documentation    DateTime-Class DateTimeZone-Class DateInterval-Class DatePeriod-Class   All these classes also offer a procedural functional way to operate with dates  Therefore take a look at the overview  http   php net manual book datetime php

User · Answer

Unfortunately the solution provided by FaileN doesn t work as stated by Walter Tross   days may not be 24 hours   I like to use the PHP Objects where possible and for a bit more flexibility I have come up with the following function           param DateTimeInterface  a     param DateTimeInterface  b     param bool               absolute Should the interval be forced to be positive      param string             cap The greatest time unit to allow        return DateInterval The difference as a time only interval     function time diff DateTimeInterface  a  DateTimeInterface  b   absolute false   cap  H          Get unix timestamps  note getTimeStamp   is limited    b raw   intval  b- gt format  U        a raw   intval  a- gt format  U           Initial Interval properties    h   0     m   0     invert   0        Is interval negative    if   absolute  amp  amp   b raw lt  a raw        invert   1            Working diff  reduced as larger time units are calculated    working   abs  b raw- a raw         If capped at hours  calc and remove hours  cap at minutes   if  cap     H          h   intval  working 3600        working -   h   3600       cap    M             If capped at minutes  calc and remove minutes   if  cap     M          m   intval  working 60        working -   m   60            Seconds remain    s    working        Build interval and invert if necessary    interval   new DateInterval  PT   h  H   m  M   s  S       interval- gt invert  invert     return  interval      This like date diff   creates a DateTimeInterval  but with the highest unit as hours rather than years   it can be formatted as usual    interval   time diff  date a   date b   echo  interval- gt format   r H       For hours  with sign    N B  I have used format  U   instead of getTimestamp   because of the comment in the manual  Also note that 64-bit is required for post-epoch and pre-negative-epoch dates

User · Answer

This is working in my project  I think  This will be helpful for you   If Date is in past then invert will 1  If Date is in future then invert will 0    defaultDate   date  Y-m-d        datetime1     new DateTime  2013-03-10       datetime2     new DateTime  defaultDate      interval       datetime1- gt diff  datetime2      days           interval- gt format   a     invert         interval- gt invert

User · Answer

Carbon could also be a nice way to go   From their website      A simple PHP API extension for DateTime  http   carbon nesbot com    Example   use Carbon Carbon           day1   Carbon  createFromFormat  Y-m-d H i s    2006-04-12 12 30 00     day2   Carbon  createFromFormat  Y-m-d H i s    2006-04-14 11 30 00     echo  day1- gt diffInHours  day2      47          Carbon extends the DateTime class to inherit methods including diff    It adds nice sugars like diffInHours  diffInMintutes  diffInSeconds e t c

User · Answer

The easiest way to get the correct number of hours between two dates  datetimes   even across daylight saving time changes  is to use the difference in Unix timestamps  Unix timestamps are seconds elapsed since 1970-01-01T00 00 00 UTC  ignoring leap seconds  this is OK because you probably don t need this precision  and because it s quite difficult to take leap seconds into account    The most flexible way to convert a datetime string with optional timezone information into a Unix timestamp is to construct a DateTime object  optionally with a DateTimeZone as a second argument in the constructor   and then call its getTimestamp method    str1    2006-04-12 12 30 00     str2    2006-04-14 11 30 00    tz1   new DateTimeZone  Pacific Apia     tz2    tz1   d1   new DateTime  str1   tz1      tz is optional   d2   new DateTime  str2   tz2      and ignored if str contains tz offset  delta h     d2- gt getTimestamp   -  d1- gt getTimestamp      3600  if   rounded result        delta h   round   delta h     else if   truncated result        delta h   intval  delta h     echo   h   delta h n

User · Answer

Calculate number of hours between pass and now  dayinpass    2013-06-23 05 09 12    today   time     dayinpass  strtotime  dayinpass   echo round abs  today- dayinpass  60 60

User · Answer

To provide another method for DatePeriod when using the UTC or GMT timezone   Count Hours https   3v4l org Mu3HD   start   new  DateTime  2006-04-12T12 30 00     end   new  DateTime  2006-04-14T11 30 00       determine what interval should be used - can change to weeks  months  etc  interval   new  DateInterval  PT1H       create periods every hour between the two dates  periods   new  DatePeriod  start   interval   end      count the number of objects within the periods  hours   iterator count  periods   echo  hours     hours       difference between Unix Epoch  diff    end- gt getTimestamp   -  start- gt getTimestamp     hours    diff     60   60    echo  hours     hours  60   60       difference between days  diff    end- gt diff  start    hours    diff- gt h     diff- gt days   24   echo  hours     hours  days   24      Result  47 hours  iterator count  47 hours  60   60  47 hours  days   24      Count Hours with Daylight Savings https   3v4l org QBQUB  Please be advised that DatePeriod excludes an hour for DST but does not add another hour when DST ends  So its usage is subjective to your desired outcome and date range     See the current bug report    set timezone to UTC to disregard daylight savings date default timezone set  America New York      interval   new  DateInterval  PT1H       DST starts Apr  2nd 02 00 and moves to 03 00  start   new  DateTime  2006-04-01T12 00 00       end   new  DateTime  2006-04-02T12 00 00      periods   new  DatePeriod  start   interval   end    hours   iterator count  periods   echo  hours     hours      DST ends Oct  29th 02 00 and moves to 01 00  start   new  DateTime  2006-10-28T12 00 00     end   new  DateTime  2006-10-29T12 00 00       periods   new  DatePeriod  start   interval   end    hours   iterator count  periods   echo  hours     hours     Result   2006-04-01 12 00 EST to 2006-04-02 12 00 EDT 23 hours  iterator count    23 hours  60   60    24 hours  days   24    2006-10-28 12 00 EDT to 2006-10-29 12 00 EST 24 hours  iterator count    25 hours  60   60    24 hours  days   24    2006-01-01 12 00 EST to 2007-01-01 12 00 EST 8759 hours  iterator count    8760 hours  60   60    8760 hours  days   24     ------   2006-04-01 12 00 UTC to 2006-04-02 12 00 UTC 24 hours  iterator count    24 hours  60   60    24 hours  days   24    2006-10-28 12 00 UTC to 2006-10-29 12 00 UTC 24 hours  iterator count    24 hours  60   60    24 hours  days   24    2006-01-01 12 00 UTC to 2007-01-01 12 00 UTC 8760 hours  iterator count    8760 hours  60   60    8760 hours  days   24

User · Answer

First  you should create an interval object from a range of dates  By the wording used in this sentence alone  one can easily identify basic abstractions needed  There is an interval as a concept  and a couple of more ways to implement it  include the one already mentioned -- from a range of dates  Thus  an interval looks like that    interval       new FromRange          new FromISO8601  2017-02-14T14 27 39 00 00            new FromISO8601  2017-03-14T14 27 39 00 00            FromISO8601 has the same semantics  it s a datetime object created from iso8601-formatted string  hence the name   When you have an interval  you can format it however you like  If you need a number of full hours  you can have   new TotalFullHours  interval  - gt value      If you want a ceiled total hours  here you go    new TotalCeiledHours  interval  - gt value      For more about this approach and some examples  check out this entry

User · Answer

your answer is   round  strtotime  day2  - strtotime  day1    60 60

User · Answer

To pass a unix timestamp use this notation   now          time     now          new DateTime    now

[php] Calculate number of hours between 2 dates in PHP

Examples related to php

Examples related to datetime