calculate the number of nights between two dates

Question

I want how to extract the exact number of nights. I tried to achieve this by two ways but doesn't work. It return 20 nights but in real, it is 21 nights (March have 31 days)

$startTimeStamp = strtotime("14-03-2017");                                   
$endTimeStamp = strtotime("04-04-2017");                                     

$timeDiff = abs($endTimeStamp - $startTimeStamp);                            

$numberDays = $timeDiff/86400;  // 86400 seconds in one day                  


$numberDays = intval($numberDays);                                           

echo $numberDays;                                                            

echo floor((strtotime('04-04-2017')-strtotime('14-03-2017'))/(60*60*24));

I think you should +1 to whatever calculated days because output for any dates as per your requirement is not gonna give you output you want — Rahul, Dec 16 '16 at 11:48
Possible duplicate of [Finding the number of days between two dates](http://stackoverflow.com/questions/2040560/finding-the-number-of-days-between-two-dates) — TIGER, Dec 16 '16 at 11:56
Possible duplicate of [How to calculate the difference between two dates using PHP?](http://stackoverflow.com/questions/676824/how-to-calculate-the-difference-between-two-dates-using-php) — toesslab, Dec 16 '16 at 12:07

Octavian · Accepted Answer · 2016-12-16T13:48:29.587

9

Use the new DateTime extension, PHP 5.3+:

$date1 = new DateTime("2010-07-06");
$date2 = new DateTime("2010-07-09");

// this calculates the diff between two dates, which is the number of nights
$numberOfNights= $date2->diff($date1)->format("%a");

edited Dec 16 '16 at 13:48

answered Dec 16 '16 at 11:43

Octavian

4,519
8
28
39

$date1 = new \DateTime("2010-07-06"); $date2 = new \DateTime("2010-07-07"); || Returns 0...?? – Shankar Thiyagaraajan Dec 16 '16 at 12:21
2

@octavian Doesn't work for `18-01-2019 16:00` (Friday) and `21-01-2019 08:00` (Monday). Returns 2, correct is 3 (nights). – Jasom Dotnet Nov 16 '18 at 06:33
@ShankarThiyagaraajan https://3v4l.org/7ZfdD (it is working, it returns 1) – Octavian Nov 16 '18 at 10:03
@JasomDotnet you are correct; the script described assumes the time part of the date is uncompleted hence it is 00:00 AM. If you loose the time part, it will work https://3v4l.org/iibiD – Octavian Nov 16 '18 at 10:06
1

@Octavian time part is important sequence of information I don't want to cut :D – Jasom Dotnet Nov 17 '18 at 11:13

Mohsen · Answer 2 · 2019-03-17T08:38:41.467

-2

check this out for calculating nights

$start_ts = strtotime("2019-10-05"); 
$end_ts = strtotime("2019-10-06"); 
$diff = $end_ts - $start_ts; 
echo round($diff / 86400);//1 night

work like charm

edited Mar 17 '19 at 08:38

answered Mar 12 '19 at 06:31

Mohsen

1,295
1
15
45

calculate the number of nights between two dates

2 Answers2