SQL Query | Calculate number of weekdays between two dates | Exclude Weekends | DateDiff | DateName

This is a SQL Query tutorial.
How to calculate number of weekdays / work days between two dates?
Exclude Weekends
Date Functions - Datediff, Datename, Datepart
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - [e-mail]

[@hv0032113]

Very helpful. Best compilation for sql queries.

[@LearnatKnowstar]

Thank you

[@razrolfTV]

Thank you very much! The video was extremly helpful. Bravo. I was exactly looking for the same material as explained. Hands down. 🙌

[@LearnatKnowstar]

Glad it was helpful 🙏

[@dimpyrathore818]

Thank you. Very helpful to prepare for the interviews.

[@LearnatKnowstar]

Thank you

[@fabifs07]

Thanks a lot, Really helpful my life today.

[@LearnatKnowstar]

Thanks so much!

[@mahesh84]

thank you.. this video solved my problem in code :)

[@LearnatKnowstar]

Thank you

[@TwoUpProductions]

Very helpful. Thank you so much!

[@LearnatKnowstar]

Thank you

[@avinashc8146]

Thank you so much for videos it was simply superb

[@LearnatKnowstar]

Thank you

[@prashantbhalla3030]

Thanks a lot ❤️, saved my day 👍

[@LearnatKnowstar]

Thank you

[@lianyiwang3209]

Hi, could you explain why not consider both order date on Saturday and Sunday as 1, else 0? Same question on ship date

[@sidmylifemyrules]

Thanks a lottttt!!!! Really helpful.

[@LearnatKnowstar]

Thank you!

[@kristyowens2284]

This is really very helpful.

[@LearnatKnowstar]

Thank you

[@sachingulati9857]

Thanks for explaining the concept in such an easy way, However i wanna ask a question: Suppose the orderdate is on saturday or sunday and the delivery day is also same. What do we do in this scenario?

[@sahameed]

Great , Many Thanks. 👍

[@LearnatKnowstar]

Thank you

[@imranpathan8352]

Nice video mam.. please provide database to work

[@surajpatil3579]

Thank you for this

[@viniciusluiz8833]

Very useful!

[@LearnatKnowstar]

Thank you

[@Farhazh]

Thank you soo much very helpful!
Just one question where i am stuck from couple of days and not getting a solution. Here by default sql server considers weekend as saturday and sunday, what if i need to calculate no. Of days between 2 dates considering weekend as friday?
Request you to kindly help me with the code. Thanks :)

[@LearnatKnowstar]

Thank you. In this case, you would need to use a Calendar table that identifies the Friday as a holiday. You can then identify the working days and calculate accordingly.

[@Farhazh]

@@LearnatKnowstar thank you for the prompt response!
Was just wondering if you care to explain more about how to progress on it..

[@lingxu9697]

Is it easier to use a case and count for this scenario?

[@asmitap1863]

Is there a way to execute this in Impala/Hive?

[@CaribouDataScience]

Thanks

[@somiyasaxena1419]

Hello Ma'am, I really appreciate your work, it's like free videos, and I will learn these things but the biggest problem with me is I'm unable to do it, whether the intermediate course or advanced course. I'm so frustrated that in the end, I will see the answer. I've seen so many videos but I'm unable to do it myself. what to do? is it like for others or it's just with me?

[@LearnatKnowstar]

Thank you. Try to keep practicing with the datasets provided in the videos. Even after seeing the result, try to write the same query yourself again. If you keep practicing, you will soon learn the tricks to solve these queries. But the key is to write the query yourself every time you watch a video. Hope it helps 👍

[@rahulganga3274]

Super mam your are Great 👍 👌 😀

[@LearnatKnowstar]

Glad it was helpful.

[@rahulganga3274]

Great 👍

[@LearnatKnowstar]

Glad it was helpful!

[@jayantirawat8623]

Can I get this table create statement and select statement query

[@Avengers.119]

I need training on data stage with SQL,please provide your contract information

[@LearnatKnowstar]

We will be announcing the batches soon on our UA-cam channel. Stay tuned.

[@ramakrishnasamala4201]

well explained

[@LearnatKnowstar]

Thank you

[@vibhanshudongre]

Can you let us know from where we can download these databases for practice ?

[@LearnatKnowstar]

You can download sample databases. You can refer this video tutorial -
ua-cam.com/video/ncj0EDzy_rw/v-deo.html

[@LuckyK]

thank you. what about Holidays ? what if you have a Date table and also exclude Holidays

[@LearnatKnowstar]

Having a date table that marks weekends and holidays makes it much easier to implement this requirement as a simple join can determine whether the day is a work day or not.

[@alsonncube5831]

@@LearnatKnowstar Is it possible to do it without the date table?

[@LearnatKnowstar]

It is possible though not the preferred way.

[@LearnatKnowstar]

You will need to write a function that identifies the holidays.either by constant dates for ex Christmas always falls on 25th Dec or holidays that fall on a particular day of a week..for ex every 1st Monday of August etc.

[@zainabghassan632]

How can we find days between different dates in one
column based on user id?

[@nehakaw7685]

How to calculate if we only need to skip a Sunday and want to consider monday to saturday as weekdays

[@avinashc8146]

And ma'am can we get any place where we can interact with you

[@LearnatKnowstar]

You can always post your queries on our UA-cam channel

[@bala7965]

How to get caender passing month year using SQL pls tell me

[@LearnatKnowstar]

Will cover it in a future video

[@bala7965]

@@LearnatKnowstar Bro I need it my project taskif you know this please reply me

[@sidmishra8252]

But like from 11 to 24 you have 2 Sunday and 2 Saturday. So, you should take it as total 4 off days

[@MangeshBarhatemyav]

How calculate last week of year date - next year any date first week date . I tried

[@theduck72]

Nice

[@LearnatKnowstar]

Thanks

[@ngneerin]

Will work incorrectly if order date is 2015-01-11 and ship date is 2015-01-25

[@ishitvasingh9902]

I have a doubt,
in your final querie's 3rd line of code, if we could have added +1 , would it work?
seelct orderdate, shipdate,
(datediff(dd, order, shipdate) +1) -
((datediff (ww, orderdate, shipdate) * 2 ) + 1)
from sales
would it work ? Please do answer

[@KajalSharma16]

It is not working for TEradata (datediff function)

[@KajalSharma16]

ALTER TABLE mytable
ADD difference_dt as DATEDIFF(DAY, start_dt, end_DT ) ; gives an error "Syntax error, expected something like a 'TRANSACTIONTIME' keyword between the 'as' keyword and the word 'DATEDIFF'." or
SELECT DATEDIFF(day, start_dt, end_DT) as difference FROM mytable gives error "Syntax error: expected something between '(' and the 'day' keyword." kindly let me know

[@LearnatKnowstar]

Datediff function is not a valid teradata function. You will need to subtract two days to get the difference.
You can refer here
docs.teradata.com/r/1DcoER_KpnGTfgPinRAFUw/WdO2taOuHi5IaUk0dEsJTg

[@upanshukumar7472]

Mam plz explain in hindi also

[@LearnatKnowstar]

Thank you. Will try to do some Hindi videos in the future 👍

[@danieljust295]

This is not working solution, works conditionally only.