Hi,
Zitat von
Nightshade:
Code:
DATEDIFF(expr,expr2)
DATEDIFF() returns the number of days between the start date expr and the end date expr2. expr and expr2 are date or date-and-time expressions. Only the date parts of the values are used in the calculation.
mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
-> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
-> -31
DATEDIFF() was added in
MySQL 4.1.1.
Wie gesagt ich brauche das in Tagen Stunden , Minuten...
Ich denke die Lösung von Berserker wird mir weiterhelfen. Ich schaue mal.
Danke!