How can we know the number of days between two given dates
using PHP?
How can we know the number of days between two given dates
using MySQL?

Answers were Sorted based on User's Feedback



How can we know the number of days between two given dates using PHP? How can we know the number..

Answer / abdulgafoor

Using PHP

$date1 = date("Y-m-d");
$date2= "2005-5-15";
$nodays = (strtotime()-strtotime())/(60*60*24);

echo "no of days are $nodays ";

Using mySql :

mysql>SELECT DATEDIFF(NOW(),'2005-5-15');
The output will give you the exact number of days.

Is This Answer Correct ?    12 Yes 4 No

How can we know the number of days between two given dates using PHP? How can we know the number..

Answer / shaik abdul raheem

SELECT DATEDIFF('2006-04-01','2006-03-01')

Is This Answer Correct ?    6 Yes 0 No

How can we know the number of days between two given dates using PHP? How can we know the number..

Answer / jitendra jhariya and sandeep s

function dateDiff($dformat, $endDate, $beginDate)
{
$date_parts1=explode($dformat, $beginDate);
$date_parts2=explode($dformat, $endDate);
$start_date=gregoriantojd($date_parts1[0], $date_parts1[1],
$date_parts1[2]);
$end_date=gregoriantojd($date_parts2[0], $date_parts2[1],
$date_parts2[2]);
return $end_date - $start_date;
}Now let us see how we use this function:$date1="07/11/2003";
$date2="09/04/2004";print "If we minus " . $date1 . " from "
. $date2 . " we get " . dateDiff("/", $date2, $date1) .
".";which generates If we minus 07/11/2003 from 09/04/2004
we get 421.

Is This Answer Correct ?    6 Yes 1 No

How can we know the number of days between two given dates using PHP? How can we know the number..

Answer / vipul dalwala

php
-------------------------------------------------------
$noofdays = ceil(((strtotime($endDate) - strtotime
($startDate)) / (60*60*24)))


Mysql
-------------------------------------------------------
SELECT ((UNIX_TIMESTAMP('2007-10-01') - UNIX_TIMESTAMP
('2007-09-04'))/(60*60*24)) AS dateDiff;

Is This Answer Correct ?    5 Yes 4 No

How can we know the number of days between two given dates using PHP? How can we know the number..

Answer / vinay sachan

<?PHP
// different between two dates by date_diff() function:-
$datetime1 = date_create('2010-01-01');
$datetime2 = date_create('2012-1-15');
$interval = date_diff($datetime1, $datetime2);
echo $interval->format('%a days')."<br>";
//+744 days
echo $interval->format('%y-%m-%d days')."<br>";
//2-0-14 days
// different between two dates by strtotime() function:-
$now = time(); // or your date as well
$your_date = strtotime("2010-01-01");
$datediff = $now - $your_date;
echo floor($datediff/(60*60*24)) ."<br>";
//744
?>

for more PHP questions and their best answers and PHP notes at http://onlinephpstudy.blogspot.com/

Is This Answer Correct ?    1 Yes 0 No

How can we know the number of days between two given dates using PHP? How can we know the number..

Answer / indira majumder

<?php
$date1 = date('y-m-d');
$date2 = '2007-12-7';
$days = (strtotime($date2)-strtotime($date1))/(60*60*24);
echo "Number of Days since '2007-12-7': $days";

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More PHP Interview Questions

How to call javascript function in php on button click?

0 Answers  


Is php difficult to learn?

0 Answers  


What are the different data types in javascript?

1 Answers  


How can I use single quotes in single quotes in php?

0 Answers  


Specify pre-defined classes in php ?

1 Answers  


What is xss and csrf?

0 Answers  


Explain the ternary conditional operator in php?

0 Answers  


What is difference between Method overriding and overloading in PHP?

0 Answers  


Explain what is meant by pear in php?

0 Answers  


How can we encrypt the password using php?

0 Answers  


How can we get the browser properties using PHP?

7 Answers  


What is new static in php?

0 Answers  


Categories