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

Tell me what does pear stands for?

0 Answers  


How can we submit a form without a submit button?

23 Answers   ABC, HCL, Infosys, Kept Bug, Panys, Rushmore Consultancy, Torque Infotech, Wipro, zCon Solutions,


What are major variables in research?

0 Answers  


What are some of the advanced features of php?

0 Answers  


Tell me what are the encryption techniques in php?

0 Answers  


What is better .net or php?

0 Answers  


How many types of php frameworks are there?

0 Answers  


Is php case sensitive?

0 Answers  


What is default session time in php?

0 Answers  


hi..this is kumar...how m,uch time req for php preparation?is any coaching avaiable in vizag for php?

3 Answers  


How can you encrypt password using php?

0 Answers  


Is php still in demand?

0 Answers  


Categories