MySQL DATEDIFF: Calculate Days Between Two Dates

by

MySQL get the difference between two dates; In this tutorial, i am going to show you how to find or get difference between two dates in days using the MySQL datediff() function.

How to Find the Number of Days Between Two Dates in MySQL

The MySQL DATEDIFF function returns the difference in days between two date values.

Syntax of MySQL DATEDIFF Function

The MySQL DATEDIFF syntax is:

DATEDIFF( date1, date2 )

Parameters of MySQL DATEDIFF function

  • date1 A date/datetime value
  • date2 A date/datetime value

Examples 1 – To Find/Calculate Days Between Two Dates in Days

To find the number of days between two dates in mysql; as follows:

SELECT DATEDIFF('2019-10-10', '2019-02-15');


Output: 237

Examples 2 – To Calculate Days Between Two Dates in Days

Let’s see the following example to calculate days between two dates in days; as follows:

SELECT DATEDIFF('2019-5-10 11:41:14', '2019-02-15 12:10:08');

Output: 84

Conclusion

In this tutorial, you have learned how to use MySQL DATEDIFF function to calculate the number of days between two date values.

Create, Alter, Drop, Truncate, View in MySQL Table
Select, Insert, Update, Delete Query in MySQL
List of MySQL Clauses
MySQL Insert Into with Select Query
MySQL JOINS Tutorial – INNER, OUTER, LEFT, RIGHT, CROSS
MySQL Aggregate Function: SUM, AVG, MAX, MIN, COUNT
MySQL WHERE Clause: AND, OR, IN, NOT IN Query Example
MySQL Where IS NOT NULL Examples
MySQL IS NULL Condition
MySQL IFNULL Function with Example
MySQL Like and Not Like Wildcard Operator
MySQL BETWEEN Condition
MySQL NOT BETWEEN Operator
MySQL DATE() Function
MySQL CURRENT_DATE Function
MySQL CURDATE Function
MySQL DAY() Function
MySQL ADDDATE() Function
MySQL DATE_ADD Function
MySQL DATE_FORMAT Function
MySQL DAYNAME() Function
MySQL DAYOFMONTH() Function
MySQL MONTH Function: To Get Month From Date
MySQL MONTHNAME() Function : Get Month Name From Date
MySQL WEEK Function
MySQL YEARWEEK() Function
MySQL DAYOFWEEK() Function
MySQL WEEKDAY() Function
MySQL DAYOFYEAR() Function
MySQL WEEKOFYEAR() Function
MySQL YEAR() Function
MySQL NOW() Function
MySQL LAST_DAY Function
MySQL FROM_DAYS() Function
MySQL TO_DAYS() Function
MySQL HOUR() Function
MySQL MINUTE() Function
MySQL ADDTIME() Function
MySQL CURRENT_TIME() Function
MySQL CURRENT TIMESTAMP Function
MySQL CURTIME() Function
MySQL LOCALTIME() Function
MySQL LOCALTIMESTAMP() Function
MySQL MAKEDATE() Function
MySQL MAKETIME() Function
MySQL MICROSECOND() Function
MySQL SECOND() Function
MySQL PERIOD_ADD() Function
MySQL PERIOD_DIFF() Function
MySQL STR_TO_DATE() Function
MySQL QUARTER() Function
MySQL Convert Seconds to a Time Values
MySQL TIMESTAMP Function
MySQL TIMESTAMPDIFF() Function
MySQL TIMEDIFF() Function
MySQL Subtract Day, Hours, Minutes from DateTime
MySQL TIMESTAMPADD() Function
MySQL SUBTIME() Function
MySQL Subtract Days, Hour, Minute from Date or DateTime
MySQL Time() Function
MySQL TIME_TO_SEC() Function
How to Find the Number of Days Between Two Dates in MySQL
MySQL TIME_FORMAT Function
How to Get Data Of Current Date, Week, Month, YEAR in MySQL
How to get first day and last day of month in MySQL
MySQL Find and Delete Duplicate Records
How to Find First, Second, Third, Nth Highest Salary in MySQL
How to Get Data Of Last Day, Week, Month, YEAR in MySQL

Leave a Comment