Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Selected Reading
What is the way to find business days between two specified dates in MySQL?
With the help of DATEDIFF(expr1, expr2) we can find the business days between two specified dates.
For example, if we want to find business days between ‘2017-05-27’ and ‘2017-05-23’ then following would be MySQL query −
mysql> Select DATEDIFF('2017-05-27','2017-05-23') AS 'Total Business Days';
+----------------------+
| Total Business Days |
+----------------------+
| 4 |
+----------------------+
1 row in set (0.00 sec) Advertisements
