working days between dates

[expired user #14027]'s profile image [expired user #14027] posted 5 years ago in Creating a connection Permalink

Which function can calculate working days between dates. It is impossible to develop an algorithm. I have no idea how to do this.

ansgar's profile image ansgar posted 5 years ago Permalink

DATEDIFF calculates days between two dates:

SELECT DATEDIFF(NOW(), '2019-01-01');

But you want working days?

[expired user #14027]'s profile image [expired user #14027] posted 5 years ago Permalink

I study and I received the task in Heidsql, the information is little, and it is very difficult to fulfill it. From January 1 to calculate all working days, or to put the date of May 5, 2020 and to give the order to find out what the date will be if we choose 23 working days.

[expired user #14027]'s profile image [expired user #14027] posted 5 years ago Permalink

I study and I received the task in Heidsql, the information is little, and it is very difficult to fulfill it. From January 1 to calculate all working days, or to put the date of May 5, 2020 and to give the order to find out what the date will be if we choose 23 working days.

[expired user #14027]'s profile image [expired user #14027] posted 5 years ago Permalink

any date set to calculate the number of working days, we receive the result 282, the calculation is made only from 01.01.20 until today

Please login to leave a reply, or register at first.