How to calculate difference in days between two dates in MySQL

Let's say we have a MySQL table where one column (date or datetime type) is named activated and contains dates in one of the YYYY-MM-DD or YYYY-MM-DD HH:MM:SS formats from the past and we need to calculate the difference in days since that date untill current date for each row.

First let's see a preview of the activated column:

so we see dates lik 06th of June, 15th of October and so on. Now, let's calculate the difference between these dates and current date:

so the difference in days between 6th of June and present day is 259 days. Same with the others.

I used in the queries above two MySQL date functions: DATEDIFF() and CURDATE().

Also take a good look at MySQL Date and Time Functions and MySQL The DATETIME, DATE, and TIMESTAMP Column Types.

Bookmarks:

Echo "How to calculate difference in days between two dates in MySQL" around: