|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2010-07-29 04:49 UTC] alex dot joyce at staff dot comcen dot com dot au
Description:
------------
Trying to calculate the month difference between two dates accurately.
Test script:
---------------
<?php
$date_start = new DateTime('2010-03-01');
$date_end = new DateTime('2010-07-29');
$interval = $date_start->diff($date_end);
print_r($interval);
Expected result:
----------------
DateInterval Object
(
[y] => 0
[m] => 4
[d] => 29
[h] => 0
[i] => 0
[s] => 0
[invert] => 0
[days] => 150
)
Actual result:
--------------
DateInterval Object
(
[y] => 0
[m] => 5
[d] => 0
[h] => 0
[i] => 0
[s] => 0
[invert] => 0
[days] => 150
)
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Oct 30 18:00:02 2025 UTC |
Don't you mean 4 months and 28 days in the expected results? 7-3=4, 29-1=28 And that is exactly what I get on my Debian box with PHP 5.3.3: php > $date_start = new DateTime('2010-03-01'); php > $date_end = new DateTime('2010-07-29'); php > php > $interval = $date_start->diff($date_end); php > php > print_r($interval); DateInterval Object ( [y] => 0 [m] => 4 [d] => 28 [h] => 0 [i] => 0 [s] => 0 [invert] => 0 [days] => 150 ) Are you using 5.3.3 built from our sources or are you using a Debian-packaged version?I don't see why I can't reproduce it then. Try adding a call to date_default_timezone_set() to the top of your script and work in UTC to eliminate local timezone issues. date_default_timezone_set('UTC'); $date_start = new DateTime('2010-03-01'); $date_end = new DateTime('2010-07-29'); $interval = $date_start->diff($date_end); print_r($interval);The problem lies between the last day of February and first day of March. At the following example: $first = new DateTime('2011-03-01'); $second = new DateTime('2011-03-29'); $interval = $second->diff($first); will get the wrong result. If I set my timezone to Europe/Stockholm which is +1 GMT then if i set the $first = new DateTime(’2011-03-01 00:59:00′); I still get the wrong result. However an hour value above or equal to +1 ie $first = new DateTime(’2011-03-01 01:00:00′); will give the correct example. So if you are GMT + 2 you need to have a value above or equal to 2011-03-01 02:00:00. A quick fix, as mentioned above, is to set your timezone to UTC: date_default_timezone_set(‘UTC’); and in this case you match the time with the needed in order to get correct results. Another example with the opposite results is to set your timezone to: date_default_timezone_set(‘America/Mexico_City’); $first = new DateTime(’2011-02-28 22:01:00′); $second = new DateTime(’2011-03-29 03:00:00′); then the diff will think that you are in the same month.I think this bug is hasn't been fixed yet. Below is a reproduction on Ubuntu 11.10 with PHP 5.3.6. DateTime Object #1: ( [date] => 2011-12-01 00:00:00 [timezone_type] => 3 [timezone] => Europe/Amsterdam ) DateTime Object #2: ( [date] => 2012-02-01 00:00:00 [timezone_type] => 3 [timezone] => Europe/Amsterdam ) DateTime Object #3: ( [date] => 2011-12-01 12:00:00 [timezone_type] => 3 [timezone] => Europe/Amsterdam ) DateTime Object #4: ( [date] => 2012-02-01 12:00:00 [timezone_type] => 3 [timezone] => Europe/Amsterdam ) DateInterval Object #1 & #2 ( [y] => 0 [m] => 2 [d] => 1 [h] => 0 [i] => 0 [s] => 0 [invert] => 0 [days] => 62 ) DateInterval Object #3 & #4 ( [y] => 0 [m] => 2 [d] => 0 [h] => 0 [i] => 0 [s] => 0 [invert] => 0 [days] => 62 ) The difference in the 'd' attribute is very strange...I stumbled upon this seemingly wrong behaviour too, while studying the manual, and was all about to add a confirming comment but finally realized the reason behind it. The explanation is that the diff() method first converts its operands to UTC. In cases when the converion changes their months the number of days in the month may change too. For ex. 2010-03-01/2010-07-29 in the very 1st example, when in Europe/Copenhagen, actually converts to 2010-02-28 23:00:00/2010-07-28 23:00:00, hence the difference 5 months 0 days. The conversion explains why the number of hours in the time part matters and should be equal or greater than the timezone offset from UTC in order to avoid the effect. Another consequence of the UTC conversion is that the function does not respect any DST shifts (it that matters for you). Using strtotime() for the same dates and subtracting the timestamps might yield a different result (+/-1 hour) if a DST switch is within the dates period. I also recommend using a DateTimeZone object for DateTime instead of changing the global TZ for all date functions: $oTZ=new DateTimeZone('Europe/Moscow'); $DT1=new DateTime('2010-03-01', $oTZ);Had the same issue diff between 01-04-2014 and 01-07-2014 : DateTime Object ( [date] => 2014-04-01 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Moscow ) DateTime Object ( [date] => 2014-07-01 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Moscow ) DateInterval Object ( [y] => 0 [m] => 2 [d] => 30 [h] => 0 [i] => 0 [s] => 0 [weekday] => 0 [weekday_behavior] => 0 [first_last_day_of] => 0 [invert] => 1 [days] => 91 [special_type] => 0 [special_amount] => 0 [have_weekday_relative] => 0 [have_special_relative] => 0 ) The right interval is 3 month. Not 2 month 30 days. Both dates have same timezone. If I add date_default_timezone_set('UTC') before diff - everything works fine;I experience the same issue where the month is incorrectly calculated: $Dob = new DateTime(); $Dob->setDate(2011, 8, 31); $Dob->setTime(0,0,0); $VisitDate = new DateTime(); $VisitDate->setDate(2012, 03, 01); $VisitDate->setTime(0,0,0); $interval = $Dob->diff($VisitDate); echo $interval->m; echo $interval->d; Should return 6 & 1 but returns 5 & 30. Changing the timezones still returns unexpected results: $Dob = new DateTime(); $Dob->setTimezone(new DateTimeZone('UTC')); $Dob->setDate(2011, 8, 30); $Dob->setTime(0,0,0); $VisitDate = new DateTime(); $VisitDate->setTimezone(new DateTimeZone('UTC')); $VisitDate->setDate(2012, 2, 1); $VisitDate->setTime(0,0,0); $interval = $Dob->diff($VisitDate); echo $interval->m; (returns 5) echo $interval->d; (return 2) 2011-08-30 to 2012-03-01 return 6 months and 0 days. Tried it in on both a Linux and Windows server and same result.After trying Marcel's code I got the same 'problem' on PHP 5.6 on a 64bit Windows 10 machine. However unexpected the result, I believe it is consistent with how PHP's datetime rounds dates around. Using this example: $date1 = new DateTime('2011-08-31T00:00:00Z'); $date2 = new DateTime('2012-03-01T00:00:00Z'); $interval = $date1->diff($date2); var_dump($interval); $interval->m = 5 $interval->d = 30 The expectation might be 6 months and 1 day What I'm guessing might be happening is that PHP starts adding 1 month like so: 2011-08-31 = starting date 2011-09-31 = starting date + 1 month (but there is no such thing as sept 31!) 2011-10-01 = date now wraps around to 2011-10-01 since 2011-09-31 doesn't exist 2011-11-01 = + 1 month (2 total) 2011-12-01 = + 1 month (3 total) 2012-01-01 = + 1 month (4 total) 2012-02-01 = + 1 month (5 total) 2012-03-01 = When diff'ing PHP does NOT include the final date maybe like DatePeriod. So that could be how it arrived at 5m and 30dStill got a problems: (new DateTime('2016-10-01'))->diff((new DateTime('2016-10-31'))) // 1 month (new DateTime('2016-11-01'))->diff((new DateTime('2016-11-30'))) // 29 days either first should be 30 days, or the second one 1 month (new DateTime('2016-11-01'))->diff((new DateTime('2016-12-01'))) // 30 days but that's definitely 1 whole month and what's more interesting (new DateTime('2016-11-01'))->diff((new DateTime('2016-11-31'))) // 30 days but there is no such date as '2016-11-31', but that's probably another bug. PHP 7.0.8-0ubuntu0.16.04.3This seems to be fixed in supported versions of PHP. Therefore I'm closing this issue. php > $date_start = new DateTime('2010-03-01'); php > $date_end = new DateTime('2010-07-29'); php > php > $interval = $date_start->diff($date_end); php > php > print_r($interval); DateInterval Object ( [y] => 0 [m] => 4 [d] => 28 [h] => 0 [i] => 0 [s] => 0 [f] => 0 [weekday] => 0 [weekday_behavior] => 0 [first_last_day_of] => 0 [invert] => 0 [days] => 150 [special_type] => 0 [special_amount] => 0 [have_weekday_relative] => 0 [have_special_relative] => 0 )Don't close this issue. PHP 7.0.6 still not getting expected results... $date_start = '2017-03-01'; $date_end = '2017-03-31'; DateInterval Object ( [y] => 0 [m] => 1 [d] => 2 [h] => 0 [i] => 0 [s] => 0 [weekday] => 0 [weekday_behavior] => 0 [first_last_day_of] => 0 [invert] => 0 [days] => 30 [special_type] => 0 [special_amount] => 0 [have_weekday_relative] => 0 [have_special_relative] => 0 )another funny behavior of diff(): ``` $start = new DateTime('1922-03-26 00:00:00'); $end = new DateTime('2000-01-02 00:00:00'); echo $end->diff($start, true)->format('%Y years, %m months, %d days, %h hours, %i minutes, %s seconds'); ``` returns some minutes and seconds, although both times are exact midnight. starts to be broken on this start date or this interval length. breaks with another start time since PHP 7.3.2RC (somewhere in 1892)