$date1= '0000-00-00 00:00:00';
$date2 = '0000-00-00 00:00:00';
$total_min = floor((strtotime($date1) - strtotime($date2)) /(60)); 
$total_hour = floor($total_min/60); //floor(4.3); -> 4 and floor(9.999); -> 9
$total_day = floor($total_hour/24);
$total_week = floor($total_day/7);
$displayed_min = $total_min%60; //minute to display = total number of minute - (the number of hour*60) 
$displayed_hour = $total_hour%24; //hour to display = total number of hour - (the number of day*24)
$diplayed_day = $total_day%7; //day to display = total number of hour - (the number of week*7)
	if($total_week!=0) {
			echo $total_week.'sem ';
	}
	if($diplayed_day!=0) {
			echo $diplayed_day.'j ';
	}
	if($displayed_hour!=0) {
		        echo $displayed_hour.'h ';
	}
	if($displayed_min!=0) {
			echo $displayed_min.'min';
	}

Salut,
si comme moi tu tournes pas sous cette version de mysql, j'ai codé un ptit truc:

[php]
$date1= '0000-00-00 00:00:00';
$date2 = '0000-00-00 00:00:00';
$total_min = floor((strtotime($date1) - strtotime($date2)) /(60));
$total_hour = floor($total_min/60); //floor(4.3); -> 4 and floor(9.999); -> 9
$total_day = floor($total_hour/24);
$total_week = floor($total_day/7);
$displayed_min = $total_min%60; //minute to display = total number of minute - (the number of hour*60)
$displayed_hour = $total_hour%24; //hour to display = total number of hour - (the number of day*24)
$diplayed_day = $total_day%7; //day to display = total number of hour - (the number of week*7)
if($total_week!=0) {
echo $total_week.'sem ';
}
if($diplayed_day!=0) {
echo $diplayed_day.'j ';
}
if($displayed_hour!=0) {
echo $displayed_hour.'h ';
}
if($displayed_min!=0) {
echo $displayed_min.'min';
}
[/php]

voila ta juste a affecter des valeurs aux 2 variables.

[php]
http://www.nexen.net/docs/mysql/annotee/date-and-time-functions.php

DATEDIFF(expr,expr2)
[/php]
il a du soleil super

bonjour,
est il possible de soustraire 2 dates en direct?(format mysql ou fr)

exemple : durée entre le 04/04/2005 et le 04/04/2005 retourne 0jours
durée entre le 06/04/05 et le 10/04/2005 retourne 4 jours
mais également durée entre le 30/03/2005 et le 02/04/2005 retourne 3jours

merci d'avance