user48367
user48367
Programming language:Javascript
2021-06-04 02:46:01
0
Q:

mysql compare work days

galit
galit
Code: Javascript
2021-06-30 22:58:42 
SELECT DATEDIFF(expr1,expr2) as difference_in_days;


select DATEDIFF('2020-05-15', '2020-05-10'); //returns 5
select DATEDIFF('2020-05-13', '2020-05-16'); //returns -3
select DATEDIFF('2020-06-30', '2020-05-30'); //returns 30
0
Javad Kouhi
Javad Kouhi
Code: Javascript
2021-02-04 04:27:19 
5 * (DATEDIFF(@E, @S) DIV 7) + MID('0123444401233334012222340111123400001234000123440', 7 * WEEKDAY(@S) + WEEKDAY(@E) + 1, 1)
0

Tags

New to Communities?

Join the community