Finding the number of days between two dates

Question

How to find number of days between two dates using PHP

User · Answer

start    2013-09-08    end    2013-09-15    diff    strtotime  end - strtotime  start   24 3600   echo  diff

User · Answer

Object oriented style    datetime1   new DateTime  2009-10-11     datetime2   new DateTime  2009-10-13     interval    datetime1- gt diff  datetime2   echo  interval- gt format   R a days      Procedural style    datetime1   date create  2009-10-11     datetime2   date create  2009-10-13     interval   date diff  datetime1   datetime2   echo  interval- gt format   R a days

User · Answer

From PHP Version 5 3 and up  new date time functions have been added to get difference    datetime1   new DateTime  2010-06-20      datetime2   new DateTime  2011-06-22      difference    datetime1- gt diff  datetime2    echo  Difference     difference- gt y   years                          difference- gt m   months                          difference- gt d   days    print r  difference     Result as below   Difference  1 years  0 months  2 days  DateInterval Object        y    gt  1      m    gt  0      d    gt  2      h    gt  0      i    gt  0      s    gt  0      invert    gt  0      days    gt  367     Hope it helps

User · Answer

Try using Carbon   d1    Carbon Carbon  now  - gt subDays 92    d2    Carbon Carbon  now  - gt subDays 10    days btw    d1- gt diffInDays  d2     Also you can use    Carbon Carbon  parse       to create an object of Carbon date using given timestamp string

User · Answer

You can find dates simply by   lt  php  start    date create  1988-08-10     end      date create       Current time and date  diff     date diff   start   end     echo  The difference is    echo   diff- gt y     years     echo   diff- gt m     months     echo   diff- gt d     days     echo   diff- gt h     hours     echo   diff- gt i     minutes     echo   diff- gt s     seconds      Output  The difference is 28 years  5 months  19 days  20 hours  34 minutes  36 seconds  echo  The difference in days        diff- gt days     Output  The difference in days   10398

User · Answer

now   time       or your date as well  your date   strtotime  2010-01-31     datediff    now -  your date   echo round  datediff    60   60   24

User · Answer

datediff   floor strtotime  date1   60 60 24   - floor strtotime  date2   60 60 24      and  if needed    datediff abs  datediff

User · Answer

Change this to the day in the future  day   15      Change this to the month in the future  month   11      Change this to the year in the future  year   2012       days is the number of days between now and the date in the future  days    int   mktime  0 0 0  month  day  year  - time void   86400    echo  There are  days days until  day  month  year

User · Answer

I have tried almost all of the ways as in answers given  But neither DateTime nor date create gave me correct answers in all my test cases  Specially test with February  amp  March dates or December  amp  January dates  So  I came-up with mixed solution    public static function getMonthsDaysDiff  fromDate   toDate   includingEnding   false        d1 new DateTime  fromDate        d2 new DateTime  toDate       if  includingEnding     true            d2    d2- gt modify   1 day               diff    d2- gt diff  d1        months      diff- gt format   y     12     diff- gt format   m           lastSameDate    d1- gt modify  quot   months month quot         days   date diff          date create  d2- gt format  Y-m-d             date create  lastSameDate- gt format  Y-m-d         - gt format   a          return     months    gt   months           days    gt   days      I know  performance wise this quite expensive  And you can extend it to get Years as well

User · Answer

If you re using PHP 5 3  gt   this is by far the most accurate way of calculating the difference    earlier   new DateTime  2010-07-06     later   new DateTime  2010-07-09      diff    later- gt diff  earlier - gt format   a

User · Answer

function howManyDays  startDate  endDate          date1    strtotime  startDate   0 00 00         date2    strtotime  endDate   23 59 59         res        int    date2- date1  86400            return  res

User · Answer

Easy to using date diff   from date create date  Y-m-d      to date create  2013-03-15     diff date diff  to  from   print r  diff   echo  diff- gt format   R a days       See more at  http   blog innovsystems com php get-number-days-between-two-dates-php

User · Answer

Used this      days    strtotime  endDate  - strtotime  startDate      60   60   24   print  days    Now it works

User · Answer

function get daydiff  end date  today        if  today                     today date  Y-m-d               str   floor strtotime  end date   60 60 24   - floor strtotime  today   60 60 24        return  str     d1    2018-12-31    d2    2018-06-06   echo get daydiff  d1   d2

User · Answer

Convert your dates to unix timestamps  then substract one from the another  That will give you the difference in seconds  which you divide by 86400  amount of seconds in a day  to give you an approximate amount of days in that range   If your dates are in format 25 1 2010  01 25 2010 or 2010-01-25  you can use the strtotime function    start   strtotime  2010-01-25     end   strtotime  2010-02-20      days between   ceil abs  end -  start    86400     Using ceil rounds the amount of days up to the next full day  Use floor instead if you want to get the amount of full days between those two dates   If your dates are already in unix timestamp format  you can skip the converting and just do the  days between part  For more exotic date formats  you might have to do some custom parsing to get it right

User · Answer

If you have the times in seconds  I E  unix time stamp    then you can simply subtract the times and divide by 86400  seconds per day

User · Answer

Looking all answers I compose universal function what working on all PHP versions   if  function exists  date between          function date between  date start   date end                if   date start      date end  return 0           if  class exists  DateTime                            date start   new DateTime   date start                 date end     new DateTime   date end                return  date end- gt diff  date start - gt format   a                      else                                  return abs  round    strtotime  date start  - strtotime  date end      86400                      endif    In the general  I use  DateTime  to find days between 2 dates  But if in the some reason  some server setup not have  DateTime  enabled  it will use simple  but not safe  calculation with  strtotime

User · Answer

TL DR do not use UNIX timestamps  Do not use time    If you do  be prepared should its 98 0825  reliability fail you  Use DateTime  or Carbon   The correct answer is the one given by Saksham Gupta  other answers are also correct    date1   new DateTime  2010-07-06     date2   new DateTime  2010-07-09     days     date2- gt diff  date1 - gt format   a     Or procedurally as a one-liner         Number of days between two dates         param date  dt1    First date     param date  dt2    Second date     return int     function daysBetween  dt1   dt2        return date diff          date create  dt2             date create  dt1       - gt format   a       With a caveat  the   a  seems to indicate the absolute number of days  If you want it as a signed integer  i e  negative when the second date is before the first  then you need to use the   r  prefix  i e  format   r a      If you really must use UNIX timestamps  set the time zone to GMT to avoid most of the pitfalls detailed below   Long answer  why dividing by 24 60 60  aka 86400  is unsafe Most of the answers using UNIX timestamps  and 86400 to convert that to days  make two assumptions that  put together  can lead to scenarios with wrong results and subtle bugs that may be difficult to track  and arise even days  weeks or months after a successful deployment  It s not that the solution doesn t work - it works  Today  But it might stop working tomorrow  First mistake is not considering that when asked   quot How many days passed since yesterday  quot   a computer might truthfully answer zero if between the present and the instant indicated by  quot yesterday quot  less than one whole day has passed  Usually when converting a  quot day quot  to a UNIX timestamp  what is obtained is the timestamp for the midnight of that particular day  So between the midnights of October 1st and October 15th  fifteen days have elapsed  But between 13 00 of October 1st and 14 55 of October 15th  fifteen days minus 5 minutes have elapsed  and most solutions using floor   or doing implicit integer conversion will report one day less than expected  So   quot how many days ago was Y-m-d H i s quot   will yield the wrong answer  The second mistake is equating one day to 86400 seconds  This is almost always true - it happens often enough to overlook the times it doesn t  But the distance in seconds between two consecutive midnights is surely not 86400 at least twice a year when daylight saving time comes into play  Comparing two dates across a DST boundary will yield the wrong answer  So even if you use the  quot hack quot  of forcing all date timestamps to a fixed hour  say midnight  this is also done implicitly by various languages and frameworks when you only specify day-month-year and not also hour-minute-second  same happens with DATE type in databases such as MySQL   the widely used formula  FLOOR  unix timestamp DATE2  - unix timestamp DATE1     86400   or  floor  time   - strtotime  somedate     86400   will return  say  17 when DATE1 and DATE2 are in the same DST segment of the year  but even if the hour minute second part is identical  the argument might be 17 042  and worse still  16 958 when they are in different DST segments and the time zone is DST-aware  The use of floor   or any implicit truncation to integer will then convert what should have been a 17 to a 16  In other circumstances  expressions like  quot  days  gt  17 quot  will return true for 17 042  even if this will look as if the elapsed day count is 18  And things grow even uglier since such code is not portable across platforms  because some of them may apply leap seconds and some might not  On those platforms that do  the difference between two dates will not be 86400 but 86401  or maybe 86399  So code that worked in May and actually passed all tests will break next June when 12 99999 days are considered 12 days instead of 13  Two dates that worked in 2015 will not work in 2017 -- the same dates  and neither year is a leap year  And between 2018-03-01 and 2017-03-01  on those platforms that care  366 days will have passed instead of 365  making 2018 a leap year  which it is not   So if you really want to use UNIX timestamps   use round   function wisely  not floor     as an alternative  do not calculate differences between D1-M1-YYY1 and D2-M2-YYY2  Those dates will be really considered as D1-M1-YYY1 00 00 00 and D2-M2-YYY2 00 00 00  Rather  convert between D1-M1-YYY1 22 30 00 and D2-M2-YYY2 04 30 00  You will always get a remainder of about twenty hours  This may become twenty-one hours or nineteen  and maybe eighteen hours  fifty-nine minutes thirty-six seconds  No matter  It is a large margin which will stay there and stay positive for the foreseeable future  Now you can truncate it with floor   in safety    The correct solution though  to avoid magic constants  rounding kludges and a maintenance debt  is to  use a time library  Datetime  Carbon  whatever   don t roll your own  write comprehensive test cases using really evil date choices - across DST boundaries  across leap years  across leap seconds  and so on  as well as commonplace dates  Ideally  calls to datetime are fast   generate four whole years   and one day  worth of dates by assembling them from strings  sequentially  and ensure that the difference between the first day and the day being tested increases steadily by one  This will ensure that if anything changes in the low-level routines and leap seconds fixes try to wreak havoc  at least you will know   run those tests regularly together with the rest of the test suite  They re a matter of milliseconds  and may save you literally hours of head scratching     Whatever your solution  test it  The function funcdiff below implements one of the solutions  as it happens  the accepted one  in a real world scenario   lt  php  tz            Europe Rome    yearFrom     1980   yearTo       2020   verbose      false   function funcdiff  date2   date1         now          strtotime  date2        your date    strtotime  date1        datediff      now -  your date      return floor  datediff    60   60   24                                                date default timezone set  tz    failures     0   tests        0    dom   array   0  31  28  31  30                    31  30  31  31                    30  31  30  31     array sum  dom      365     die  quot Thirty days hath September    quot     last     array    for   year    yearFrom   year  lt   yearTo   year           dom 2    28         Apply leap year rules      if   year   4     0       dom 2    29        if   year   100     0     dom 2    28        if   year   400     0     dom 2    29        for   month   1   month  lt   12   month               for   day   1   day  lt    dom  month    day                   date   sprintf  quot  04d- 02d- 02d quot    year   month   day               if  count  last      7                     tests                      diff   funcdiff  date   test   array shift  last                    if   double  diff      double 7                         failures                         if   verbose                            print  quot There seem to be   diff  days between   date  and   test  n quot                                                                      last      date                     print  quot This function failed   failures  of its   tests  tests quot   print  quot  between   yearFrom  and   yearTo   n quot    The result is  This function failed 280 of its 14603 tests  Horror Story  the cost of  quot saving time quot  This actually happened some months ago  An ingenious programmer decided to save several microseconds off a calculation that took about thirty seconds at most  by plugging in the infamous  quot  MidnightOfDateB-MidnightOfDateA  86400 quot  code in several places  It was so obvious an optimization that he did not even document it  and the optimization passed the integration tests and lurked in the code for several months  all unnoticed  This happened in a program that calculates the wages for several top-selling salesmen  the least of which has a frightful lot more clout than a whole humble five-people programmer team taken together  One day some months ago  for reasons that matter little  the bug struck -- and some of those guys got shortchanged one whole day of fat commissions  They were definitely not amused  Infinitely worse  they lost the  already very little  faith they had in the program not being designed to surreptitiously shaft them  and pretended - and obtained - a complete  detailed code review with test cases ran and commented in layman s terms  plus a lot of red-carpet treatment in the following weeks   What can I say  on the plus side  we got rid of a lot of technical debt  and were able to rewrite and refactor several pieces of a spaghetti mess that hearkened back to a COBOL infestation in the swinging  90s  The program undoubtedly runs better now  and there s a lot more debugging information to quickly zero in when anything looks fishy  I estimate that just this last one thing will save perhaps one or two man-days per month for the foreseeable future  On the minus side  the whole brouhaha costed the company about    200 000 up front - plus face  plus undoubtedly some bargaining power  and  hence  yet more money   The guy responsible for the  quot optimization quot  had changed job a year ago  before the disaster  but still there was talk to sue him for damages  And it didn t go well with the upper echelons that it was  quot the last guy s fault quot  - it looked like a set-up for us to come up clean of the matter  and in the end  we re still in the doghouse and one of the team is planning to quit  Ninety-nine times out of one hundred  the  quot 86400 hack quot  will work flawlessly   For example in PHP  strtotime   will ignore DST  and report that between the midnights of the last Saturday of October and that of the following Monday  exactly 2   24   60   60 seconds have passed  even if that is plainly not true    and two wrongs will happily make one right   This  ladies and gentlemen  was one instance when it did not  As with air-bags and seat belts  you will perhaps never really need the complexity  and ease of use  of DateTime or Carbon  But the day when you might  or the day when you ll have to prove you thought about this  will come as a thief in the night  Be prepared

User · Answer

You can try the code below    dt1   strtotime  2019-12-12      Enter your first date  dt2   strtotime  12-12-2020      Enter your second date echo abs   dt1 -  dt2     60   60   24

User · Answer

Here is my improved version which shows 1 Year s  2 Month s  25 day s  if the 2nd parameter is passed   class App Sandbox String Util                  Usage  App Sandbox String Util  getDateDiff            param int  your date timestamp         param bool  hr human readable  e g  1 year s  2 day s          see http   stackoverflow com questions 2040560 finding-the-number-of-days-between-two-dates         see http   qSandbox com             static public function getDateDiff  your date   hr   0             now   time       or your date as well          datediff    now -  your date           days   floor   datediff     3600   24                label                if   hr                if   days  gt   365       over a year                  years   floor  days   365                    label     years     Year s                     days -  365    years                             if   days                     months   floor   days   30                     label           months     Month s                     days -  30    months                             if   days                     label           days     day s                            else                label    days                     return  label

User · Answer

I m using Carbon in my composer projects for this and similar purposes   It d be as easy as this    dt   Carbon  parse  2010-01-01    echo  dt- gt diffInDays Carbon  now

User · Answer

If you want to echo all days between the start and end date  I came up with this     startdatum     POST  start       starting date  einddatum     POST  eind       end date   now   strtotime  startdatum    your date   strtotime  einddatum    datediff    your date -  now   number   floor  datediff  60 60 24     for  i 0  i  lt    number   i          echo date  d-m-Y   strtotime      i   day      lt br gt

User · Answer

early start date   date2sql   POST  early leave date        date   new DateTime  early start date    date- gt modify   1 day       date a   new DateTime  early start date           POST  start hr             POST  start mm      date b   new DateTime  date- gt format  Y-m-d             POST  end hr             POST  end mm       interval   date diff  date a   date b      time    interval- gt format   h  i     parsed   date parse  time    seconds    parsed  hour     3600    parsed  minute     60            display error  seconds     second3    employee information  shift     60   60   if   second3  lt   seconds      display error    Leave time can not be greater than shift time Please try again                 set focus  start hr        set focus  end hr        return FALSE

User · Answer

number of days between two dates in PHP         function dateDiff  date1   date2     days find function                         diff   strtotime  date2  - strtotime  date1                return abs round  diff   86400                         start day         date1    11-10-2018                     end day         date2    31-10-2018                 call the days find fun store to variable          dateDiff   dateDiff  date1   date2            echo  Difference between two dates      dateDiff     Days

User · Answer

Well  the selected answer is not the most correct one because it will fail outside UTC  Depending on the timezone  list  there could be time adjustments creating days  without  24 hours  and this will make the calculation  60 60 24  fail   Here it is an example of it   date default timezone set  europe lisbon     time1   strtotime  2016-03-27     time2   strtotime  2016-03-29    echo floor    time2- time1    60 60 24      -- the output will be   1     So the correct solution will be using DateTime  date default timezone set  europe lisbon     date1   new DateTime  2016-03-27     date2   new DateTime  2016-03-29     echo  date2- gt diff  date1 - gt format   a      -- the output will be   2

User · Answer

Calculate the difference between two dates       date1 date create  2013-03-15     date2 date create  2013-12-12      diff date diff  date1  date2    echo  diff- gt format   R a days      Output   272 days  The date diff   function returns the difference between two DateTime objects

User · Answer

Easiest way to find the days difference between two dates   date1   strtotime  2019-05-25      date2   strtotime  2010-06-23      date difference    date2 -  date1    result    round   date difference    60   60   24      echo  result

User · Answer

Using this simple function  Declare function   lt  php function dateDiff  firstDate  secondDate        firstDate   strtotime  firstDate        secondDate   strtotime  secondDate         datediff    firstDate -  secondDate       output   round  datediff    60   60   24        return  output      gt    and call this function like this where you want   lt  php     echo dateDiff  2018-01-01   2018-12-31            OR       firstDate    2018-01-01        secondDate    2018-01-01       echo dateDiff  firstDate  secondDate         gt

User · Answer

lt  php  date1 date create  2013-03-15     date2 date create  2013-12-12     diff date diff  date1  date2   echo  diff- gt format   R a days      gt    used the above code very simple  Thanks

User · Answer

This works    start   strtotime  2010-01-25     end   strtotime  2010-02-20      days between   ceil abs  end -  start    86400

User · Answer

diff   strtotime  2019-11-25   - strtotime  2019-11-10    echo abs round  diff   86400

User · Answer

If you are using MySql  function daysSince  date   date2    q    SELECT DATEDIFF   date    date2   AS days     result   execQ  q    row   mysql fetch array  result MYSQL BOTH   return   row 0         function execQ  q    result   mysql query   q   if   result  echo   Database error execQ    mysql error    echo  q       return  result

User · Answer

I read all previous solutions  none of them use PHP 5 3 tools  DateTime  Diff and DateInterval  Days  DateInterval  Days contains exactly the right numbers of days between to date  It is not necessary to create something special and bizarre          We suppose that PHP is configured in UTC    php ini configuration      Date       Defines the default timezone used by the date functions      http   php net date timezone    date timezone   UTC     link http   php net date timezone             getDaysBetween2Dates       Return the difference of days between  date1 and  date2   date1 -  date2     if  absolute parameter is false  the return value is negative if  date2 is after than  date1        param DateTime  date1     param DateTime  date2     param Boolean  absolute                 true     return integer     function getDaysBetween2Dates DateTime  date1  DateTime  date2   absolute   true         interval    date2- gt diff  date1          if we have to take in account the relative position    absolute  and the relative position is negative         we return negatif value otherwise  we return the absolute value     return    absolute and  interval- gt invert    -  interval- gt days    interval- gt days     echo   lt h3 gt 2020-03-01 - 2020-02-01  29 days as it  s a standard leap year lt  h3 gt    echo getDaysBetween2Dates new DateTime  2020-03-01    new DateTime  2020-02-01    false    echo   lt h3 gt 1900-03-01 - 1900-02-01  28 days as it  s a  standard  century lt  h3 gt    echo getDaysBetween2Dates new DateTime  1900-03-01    new DateTime  1900-02-01    false    echo   lt h3 gt 2000-03-01 - 2000-02-01  29 days as it  s a century multiple of 400  2000 400x5 lt  h3 gt    echo getDaysBetween2Dates new DateTime  2000-03-01    new DateTime  2000-02-01    false    echo   lt h3 gt 2020-03-01 - 2020-04-01  -28 days as 2020-03-01 is before 2020-04-01 lt  h3 gt    echo getDaysBetween2Dates new DateTime  2020-02-01    new DateTime  2020-03-01    false

[php] Finding the number of days between two dates

Examples related to php

Examples related to datetime