MySQL DATEDIFF Function Guide
The datediff function in MySQL is used to calculate the difference in days between two dates. Its syntax is as follows:
Calculate the difference in days between two dates.
date1 and date2 are the two dates to be compared.
Example Usage:
- Calculate the difference in days between two dates.
Return the difference in days between January 1, 2020 and January 10, 2020.
The result is -9, indicating that the first date is 9 days earlier than the second date.
- Calculate the difference in days using the dates column in the table.
Calculate the difference in days between the end date and start date in my_table.
Assuming that my_table is a table containing the fields start_date and end_date, the query above will return the difference in dates for each row of records.
