How to calculate difference in days between two dates in MySQL mysql difference between two dates, calculate day difference
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:
Designed and developed by Andrei Manescu. Optimized for Mozilla Firefox.
Copyright 2007 Andrei Manescu
All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by those who posted them.