How MySQL DATEDIFF() function works?

MySQL DATEDIFF() function returns the number of days between two dates. The syntax of this function is as follows −

DATEDIFF(date1,date2)

For example, if we want to know a number of days between dates say ‘2017-10-22’ and ‘2017-09-21’ then we can use DATEDIFF() function as follows −

mysql> Select DATEDIFF('2017-10-22','2017-09-21') AS 'NUMBER OF DAYS';

+----------------+
| NUMBER OF DAYS |
+----------------+
|            31  |
+----------------+
1 row in set (0.00 sec)

Smita Kapse

Published on 19-Feb-2018 10:32:00

• Related Questions & Answers
• How EXPORT_SET() function works in MySQL?
• In MySQL, how IN() comparison function works?
• How does MYSQL control flow function CASE works?
• How can we ignore the negative values return by MySQL DATEDIFF() function?
• How can I use 2-digit year value in MySQL DATEDIFF() function?
• How variable scope works in Python function?
• Explain how the logistic regression function works with Tensorflow?
• How JVM works?
• What MySQL returns if we include time components along with date component as an argument to DATEDIFF() function?
• How Web Service Works?
• How scriptblock works in PowerShell?
• How does jQuery event namespace works?
• How do Python Dictionary Searching works?
• How does JavaScript focus() method works?
• How Ternary operator in PowerShell Works?