Possible Duplicates:
Number of seconds from now[] to Sunday midnight
Calculates difference between two dates in PHP
Hello All,
In my project, I need to calculate the difference in seconds between two dates:
For Example :
$firstDay = "2011-05-12 18:20:20";
$secondDay = "2011-05-13 18:20:20";
Then I should get 86400 Seconds That is 24 hours.
Similarly For
$firstDay = "2011-05-13 11:59:20";
$secondDay = "2011-05-13 12:00:20";
It should return 60 Seconds.
I read lots
of questions in the stackoverflow But they only deals with the difference between 2 minute fields like 11:50:01 and 12:10:57
asked May 13, 2011 at 7:07
1
$timeFirst = strtotime['2011-05-12 18:20:20'];
$timeSecond = strtotime['2011-05-13 18:20:20'];
$differenceInSeconds = $timeSecond - $timeFirst;
You will then be able to use the seconds to find minutes, hours, days, etc.
Gordon
307k72 gold badges526 silver badges551 bronze badges
answered May 13, 2011 at 7:13
JordoniasJordonias
5,6682 gold badges20 silver badges32 bronze badges
0
By default there's no method available on the DateTime or DateInterval class to get the difference between two DateTime objects in seconds. Therefore, you can either get the difference of the timestamps of the two dates or calculate the number of seconds yourself:
Comparing Timestamps to Get Number of Seconds Between Two Dates
We can simply compare timestamps of two dates to get the difference in seconds. For example:
$start = new DateTime['2011-12-31 00:00:00']; $end = new DateTime['2021-01-01 00:00:00']; echo $end->getTimestamp[] - $start->getTimestamp[]; // output: 284169600
Please note that comparing timestamps could lead to problems with dates before 1970 and after 2038.
Calculating Number of Seconds Between Two Dates
You can calculate the number of seconds between the two dates in the following way:
$start = new DateTime['2011-12-31 00:00:00']; $end = new DateTime['2021-01-01 00:00:00']; $diff = $start->diff[$end]; $daysInSecs = $diff->format['%r%a'] * 24 * 60 * 60; $hoursInSecs = $diff->h * 60 * 60; $minsInSecs = $diff->i * 60; $seconds = $daysInSecs + $hoursInSecs + $minsInSecs + $diff->s; echo $seconds; // output: 284169600
The calculation works in the following way:
- Using the
%rformatting character, adds the minus sign when the result is negative; - Using the
%aformatting character gives us the total number of days between two dates; - Using the
%r%aformat together, we can get the negative/positive number of days. Using that, we can convert the number of days into seconds by multiplying it with hours in a day, minutes in an hour, and seconds in a minute [i.e.days * 24 * 60 * 60]; - The calculation in the last step does not take into account the hours, minutes and seconds in the date difference [as they're not included in the
%aformat]. To include those, we simply use the hour, minute and second properties available on theDateIntervalobject and convert them into seconds as shown in the example above.
Hope you found this post useful. It was published 01 Jan, 2021. Please show your love and support by sharing this post.
In this article, we will see how to calculate the difference between 2 dates in PHP, along with understanding its implementation through the examples. Given two dates ie., start_date and end_date & we need to find the difference between the two dates.
Consider the below example:
Input: start_date: 2016-06-01 22:45:00
end_date: 2018-09-21 10:44:01
Output: 2 years, 3 months, 21 days, 11 hours, 59 minutes, 1 seconds
Explanation: The difference of 2 dates will give the date in complete format.Method 1: Using date_diff[] Function
This function is used to find the difference between two dates. This function will return a DateInterval object on the success and returns FALSE on failure.
Example: This example illustrates the use of the date_diff[] function to calculate the difference between the 2 dates.
PHP
Output:
+2 years 3 months
Method 2: To use the date-time mathematical formula to find the difference between two dates. It returns the years, months, days, hours, minutes, seconds between two specified dates.
Example: In this example, we will be using the date-time mathematical formula to calculate the difference between the dates that will be returned in years, months, days, hours, minutes, seconds.
PHP
Output:
2 years, 3 months, 21 days, 11 hours, 59 minutes, 1 seconds
Method 3: This method is used to get the total number of days between two specified dates.
PHP
Output:
Difference between two dates: 103
PHP is a server-side scripting language designed specifically for web development. You can learn PHP from the ground up by following this PHP Tutorial and PHP Examples.