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

[@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 🙏

[@Beyondhorizons-i5z]

Thank you. Very helpful to prepare for the interviews.

[@LearnatKnowstar]

Thank you

[@mahesh84]

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

[@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

[@fabifs07]

Thanks a lot, Really helpful my life today.

[@LearnatKnowstar]

Thanks so much!

[@sahameed]

Great , Many Thanks. 👍

[@LearnatKnowstar]

Thank you

[@kristyowens2284]

This is really very helpful.

[@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!

[@viniciusluiz8833]

Very useful!

[@LearnatKnowstar]

Thank you

[@TwoUpProductions]

Very helpful. Thank you so much!

[@LearnatKnowstar]

Thank you

[@kingsleyarisah6354]

Great content

[@LearnatKnowstar]

Thank You!

[@rahulganga3274]

Super mam your are Great 👍 👌 😀

[@LearnatKnowstar]

Glad it was helpful.

[@rahulganga3274]

Great 👍

[@LearnatKnowstar]

Glad it was helpful!

[@imranpathan8352]

Nice video mam.. please provide database to work

[@jayantirawat8623]

Can I get this table create statement and select statement query

[@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?

[@CaribouDataScience]

Thanks

[@ramakrishnasamala4201]

well explained

[@LearnatKnowstar]

Thank you

[@surajpatil3579]

Thank you for this

[@lingxu9697]

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

[@asmitap1863]

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

[@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.

[@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 KZbin channel. Stay tuned.

[@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..

[@avinashc8146]

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

[@LearnatKnowstar]

You can always post your queries on our KZbin channel

[@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 👍

[@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 - kzbin.info/www/bejne/pJTNYXh6r96SqNk

[@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

[@theduck72]

Nice

[@LearnatKnowstar]

Thanks

[@zainabghassan632]

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

[@ngneerin]

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

[@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

[@nehakaw7685]

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

[@landchennai8549]

alter function ufn_getweekdaysbetweentwodate(@StartDate Datetime, @EndDate datetime) returns int as begin declare @Cnt int select @Cnt = count(1) from generate_series(0,datediff(dd,@StartDate, @EndDate) -1,1) where Datename(dw, @StartDate +Value) not in ('Saturday','Sunday') return @Cnt end declare @StartDate datetime = getdate(), @EndDate datetime = getdate() +10 select @StartDate as StartDate, @EndDate as EndDate,dbo.ufn_getweekdaysbetweentwodate (@StartDate,@EndDate) as WeekDaysbwtwodates

[@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

[@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.