What about the DATEDIFF function ?
Quoting the manual's page :
DATEDIFF() returns expr1 – expr2
expressed as a value in days from one
date to the other. expr1 and expr2
are date or date-and-time expressions.
Only the date parts of the values are
used in the calculation
In your case, you'd use :
mysql> select datediff('2010-04-15', '2010-04-12');
+--------------------------------------+
| datediff('2010-04-15', '2010-04-12') |
+--------------------------------------+
| 3 |
+--------------------------------------+
1 row in set (0,00 sec)
But note the dates should be written as YYYY-MM-DD
, and not DD-MM-YYYY
like you posted.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…