Input
startdate - 2020-05-01 10:05:07.000
enddate - 2020-05-18 12:08:07.000
Expected Output
12D:02H:03M
I need output like aobve which is having hours minutes with days
Iam having query from which iam getting only working days ,below is the query
- SELECT (DATEDIFF(dd, receive_date, GETDATE()) + 1)
- -(DATEDIFF(wk, receive_date, GETDATE()) * 2)
- -(CASE WHEN DATENAME(dw, receive_date) = 'Sunday' THEN 1 ELSE 0 END)
- -(CASE WHEN DATENAME(dw, GETDATE()) = 'Saturday' THEN 1 ELSE 0 END) from email
other query i have like this
- select dbo.fn_WorkDays(receive_date, getdate() ) from email
Ayesha FathimaPosted May 18, 2020, 7:43 AM
Arvind KushwahaPosted May 18, 2020, 7:07 AM