MySQL: Days since Date

You can just use the MySQL function DATEDIFF(). This function returns the difference between two timestamps measured in days.

Here is an example of how to use it:

SELECT id, txt, dat, DATEDIFF(CURDATE(), dat) FROM tab;

In this example, our table "tab" is consisting of the columns "id", "txt" and "dat". The date of the contribution is stored in the column "dat".

We want to read out the content of all columns as well as the passed days since that date in "dat". For this, we are using the function DATEDIFF() with passing the current date with CURDATE() and the date of the column "dat" in order to get the time difference.
2016-02-23 at 16:02