php compare difference between two dates

Question

Im trying to return the difference between 2 dates, i'm working according to the example found on stackoverflow

My Problem? Im getting completely the wrong results returned, the following code returns 30 years, 0 months, 9 days, when it should obviously be only 7 days or 1 week.

Code follows below:

    date_default_timezone_set('America/Los_Angeles');

    $pickupDate = '2016-10-13';
    $returnDate  = 2016-10-20;

    $diff = abs(strtotime($pickupDate) - strtotime($returnDate));
    $years = floor($diff / (365*60*60*24));
    $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
    $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

    printf("%d years, %d months, %d days\n", $years, $months, $days);

Any input appreciated

Use PHP's built-in date functions, don't do naive hours*days calculations. — Dai
– Dai, Commented Oct 12, 2016 at 4:43

Veshraj Joshi · Accepted Answer · 2016-10-12 04:56:31Z

1

just put single quote in return date like $returnDate = '2016-10-20'; and you can use date_diff() function of php like,

$daysdiffernce = date_diff(date_create('2016-10-13'),date_create('2016-10-20'));
echo $daysdiffernce->format("%R%a days");

and this will give exactly +7days answer

answered Oct 12, 2016 at 4:56

Veshraj Joshi

3,5874 gold badges32 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim C Over a year ago

Worked like a charm; everyday you learn something new date_diff() Thank you

Zbynek Vyskovsky - kvr000 · Accepted Answer · 2016-10-12 04:47:09Z

1

First, the code doesn't take into account leap years, varying length of months and things like that.

There is actually a function in php for this, please check the link for details: http://php.net/manual/en/datetime.diff.php , and an example taken:

$datetime1 = new DateTime('2016-10-13');
$datetime2 = new DateTime('2016-10-20');
$interval = $datetime1->diff($datetime2);
echo $interval->format('%y years, %m months, %d days');

answered Oct 12, 2016 at 4:47

Zbynek Vyskovsky - kvr000

19.1k3 gold badges41 silver badges49 bronze badges

Comments

Dave · Accepted Answer · 2016-10-12 04:47:20Z

1

Try this, it will give you differ in date, and , time, minutes, hour ,second ,and etc.

date_default_timezone_set('America/Los_Angeles');
$now = '2016-10-13';
$returnDate  = '2016-10-20';
$start = date_create($returnDate);
$end = date_create($now);
$diff=date_diff($end,$start);
print_r($diff);

DEMO

answered Oct 12, 2016 at 4:47

Dave

3,0917 gold badges22 silver badges33 bronze badges

Comments

ArtisticPhoenix · Accepted Answer · 2016-10-12 04:47:29Z

1

From the manual

 $pickupDate = new DateTime('2016-10-13');
 $returnDate = new DateTime('2016-10-20');
 $interval = $pickupDate->diff($returnDate);
 echo $interval->format('%R%a days');

http://php.net/manual/en/datetime.diff.php

answered Oct 12, 2016 at 4:47

ArtisticPhoenix

21.7k2 gold badges27 silver badges38 bronze badges

Comments

Md. Sahedul Hasan · Accepted Answer · 2016-10-12 04:47:45Z

1

date_default_timezone_set('America/Los_Angeles');

$pickupDate = '2016-10-13';
$returnDate  = '2016-10-20'; //use signle quote same as pickupDate 

$diff = abs(strtotime($returnDate) - strtotime($pickupDate)); // change the order 
$years = floor($diff / (365*60*60*24));
$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

printf("%d years, %d months, %d days\n", $years, $months, $days);

Thanks

answered Oct 12, 2016 at 4:47

Md. Sahedul Hasan

693 bronze badges

Collectives™ on Stack Overflow

php compare difference between two dates

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related