PHP Simple Date Calculations

[user-7256]

Hey,

I have date stored in this format:

MM-DD-YYYY

Actually I have 2, but they're different, just in the same format.

I want to know the difference in DAYS between them. (e.g. 30 days apart, 20 days, are the two differences I really want...)

Any help appreciated!

-Matt

 

[iNod]

Explode Method

$dos = explode("-", $date);
$dos2 = explode("-", $date2);

$dbetween = $dos['2']-$dos2['2'];

List & Split Method

list($month, $day, $year) = split('[-]', $date);
list($month2, $day2, $year2) = split('[-]', $date2);

$dbetween = $day-$day2;

iNod.

 

[user-7256]

That's what I thought at first, but suppose the day is 2 and the other day is 19 ... but totally different months...

 

[Kate]

Keep it simple... Since you are extracting data from a DB (mySQL ?) use the built-in date functions.

SELECT DATEDIFF(start_date,end_date) as number_days

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

 

[iNod]

Keep it simple... Since you are extracting data from a DB (mySQL ?) use the built-in date functions.

SELECT DATEDIFF(start_date,end_date) as number_days

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Oh.. Wow.. I never knew they had a built in function. I just noticed. 5.0.. Alot of hosts don't use MySql 5.0.. So that would cause some problems.

iNod.

 

[Kate]

I believe DATEDIFF is available in MySQL 4.1.1 and above.
If you are unsure which version you are running check with this command:

SELECT VERSION()

 

[user-7256]

SDS - can you CONFIRM that I can use that function with 4.1.1? If so and it works I'll hand over some NP$.

 

[iNod]

SDS - can you CONFIRM that I can use that function with 4.1.1? If so and it works I'll hand over some NP$.

DATEDIFF is in mysql versions 4.1 and up. As said here.
http://www.mysqlfreaks.com/statements/56.php

iNod.

 

[eagle12]

PHP method:

<?
	$t = explode("-","08-28-1979");
	$date1 = strtotime($t[2].'-'.$t[1].'-'.$t[0]);

	$t = explode("-","08-28-1980");
	$date2 = strtotime($t[2].'-'.$t[1].'-'.$t[0]);

	$diff = ($date2-$date1)/86400;
?>