How to get the number of days of difference between two dates on MySQL?

by

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.

More Related Contents:

  1. Get a list of dates between two dates
  2. How to populate a table with a range of dates?
  3. MySQL Query GROUP BY day / month / year
  4. Converting a date in MySQL from string field
  5. MySQL: Select All Dates In a Range Even If No Records Present
  6. Mysql: Select all data between two dates
  7. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  8. MySQL Query – Records between Today and Last 30 Days
  9. Difference between two dates in MySQL
  10. CURRENT_DATE/CURDATE() not working as default DATE value
  11. How to get difference between two dates in months using MySQL query?
  12. Select mysql query between date?
  13. How to select date from datetime column?
  14. mysql: get record count between two date-time
  15. How to get first day of every corresponding month in mysql?
  16. Count days between two dates, excluding weekends (MySQL only)
  17. How to select the most recent set of dated records from a mysql table
  18. How to cast DATETIME as a DATE in mysql?
  19. MySQL date format
  20. Compare only day and month with date field in mysql
  21. How to select only date from a DATETIME field in MySQL?
  22. Select all months within given date span, including the ones with 0 values
  23. Update date + one year in mysql
  24. Insert/ Update random date in MySQL
  25. mysql date comparison with date_format
  26. How to compare timestamp dates with date-only parameter in MySQL?
  27. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  28. MySQL cumulative sum grouped by date
  29. MySQL: Find Missing Dates Between a Date Range
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment