MySQL - Selecting how many "Days Old" a field is

Question

How can I select how many days old a field is based on it's "DateAdded" field?

E.g.:

SELECT DAYSOLD(tbl_stuff.DateAdded) as DaysOld 
  FROM tbl_stuff

Answer 1

Use:

SELECT DATEDIFF(NOW(), ts.dateadded) AS daysold
  FROM TBL_STUFF ts

Reference: DATEDIFF

DATEDIFF() returns expr1 – expr2 expressed as a value in days from one date to the other.

Answer 2

You can use the DATEDIFF function, to get the difference, in days, between tbl_stuff.DateAdded and curdate().

For example :

mysql> select datediff(curdate(), '2010-03-15') as daysOld;
+---------+
| daysOld |
+---------+
|       8 |
+---------+