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

Подписаться 44 тыс.

Просмотров 52 тыс.

50% 1

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 - learn@knowstar.org

Опубликовано:

14 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 71

@hv0032113 3 года назад

Very helpful. Best compilation for sql queries.

@LearnatKnowstar 3 года назад

Thank you

@dimpyrathore818 3 года назад

Thank you. Very helpful to prepare for the interviews.

@LearnatKnowstar 3 года назад

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 🙏

@fabifs07 3 года назад

Thanks a lot, Really helpful my life today.

@LearnatKnowstar 3 года назад

Thanks so much!

@mahesh84 3 года назад

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

@LearnatKnowstar 3 года назад

Thank you

@CaribouDataScience Год назад

Thanks

@TwoUpProductions 3 года назад

Very helpful. Thank you so much!

@LearnatKnowstar 3 года назад

Thank you

@avinashc8146 2 года назад

Thank you so much for videos it was simply superb

@LearnatKnowstar 2 года назад

Thank you

@prashantbhalla3030 3 года назад

Thanks a lot ❤️, saved my day 👍

@LearnatKnowstar 3 года назад

Thank you

@surajpatil3579 2 года назад

Thank you for this

@sidmylifemyrules 3 года назад

Thanks a lottttt!!!! Really helpful.

@LearnatKnowstar 3 года назад

Thank you!

@kristyowens2284 3 года назад

This is really very helpful.

@LearnatKnowstar 3 года назад

Thank you

@sahameed 2 года назад

Great , Many Thanks. 👍

@LearnatKnowstar 2 года назад

Thank you

@viniciusluiz8833 3 года назад

Very useful!

@LearnatKnowstar 3 года назад

Thank you

@imranpathan8352 3 года назад

Nice video mam.. please provide database to work

@rahulganga3274 Год назад

Super mam your are Great 👍 👌 😀

@LearnatKnowstar Год назад

Glad it was helpful.

@lianyiwang3209 2 года назад

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

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

@rahulganga3274 Год назад

Great 👍

@LearnatKnowstar Год назад

Glad it was helpful!

@lingxu9697 2 года назад

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

@ramakrishnasamala4201 2 года назад

well explained

@LearnatKnowstar 2 года назад

Thank you

@asmitap1863 3 года назад

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

@Farhazh 3 года назад

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 3 года назад

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 3 года назад

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

@theduck72 Год назад

Nice

@LearnatKnowstar Год назад

Thanks

@jayantirawat8623 Год назад

Can I get this table create statement and select statement query

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

@Avengers.119 3 года назад

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

@LearnatKnowstar 3 года назад

We will be announcing the batches soon on our RU-vid channel. Stay tuned.

@vibhanshudongre 2 года назад

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

@LearnatKnowstar 2 года назад

You can download sample databases. You can refer this video tutorial - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ncj0EDzy_rw.html

@zainabghassan632 2 года назад

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

@LuckyK 3 года назад

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

@LearnatKnowstar 3 года назад

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 3 года назад

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

@LearnatKnowstar 3 года назад

It is possible though not the preferred way.

@LearnatKnowstar 3 года назад

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.

@nehakaw7685 2 года назад

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

@avinashc8146 2 года назад

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

@LearnatKnowstar 2 года назад

You can always post your queries on our RU-vid channel

@sidmishra8252 Год назад

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

@bala7965 3 года назад

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

@LearnatKnowstar 3 года назад

Will cover it in a future video

@bala7965 3 года назад

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

@MangeshBarhatemyav 2 года назад

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

@ngneerin 2 года назад

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

@KajalSharma16 2 года назад

It is not working for TEradata (datediff function)

@KajalSharma16 2 года назад

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 2 года назад

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

@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