- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the way to find business days between two specified dates in MySQL?
<p>With the help of DATEDIFF(expr1, expr2) we can find the business days between two specified dates.</p><p style="">For example, if we want to find business days between ‘2017-05-27’ and ‘2017-05-23’ then following would be MySQL query −</p><pre class="prettyprint notranslate">mysql> Select DATEDIFF('2017-05-27','2017-05-23') AS 'Total Business Days'; +----------------------+ | Total Business Days | +----------------------+ | 4 | +----------------------+ 1 row in set (0.00 sec)</pre>
Updated on 28-Jan-2020 10:00:44
- Related Questions & Answers
- How can I calculate full 24hour days between two specified dates in MySQL?
- Find number of days between two given dates in C++
- Python program to find number of days between two given dates
- How to count days between two dates in Java
- Finding Number of Days Between Two Dates JavaScript
- Find the difference between two timestamps in days with MySQL
- Find the number of logins between two dates in MySQL
- How to get the number of days between two Dates in JavaScript?
- MySQL query to calculate the days between two dates from different columns but similar rows
- How to find the number of days and number of weeks between two dates in R?
- Perform MySQL search between two dates
- How to query between two dates in MySQL?
- How do I get the number of days between two dates in JavaScript?
- Find objects between two dates in MongoDB?
- Select the date records between two dates in MySQL
Advertisements