SQL tutorial | Date Functions | Difference between DATEDIFF and DATEADD

[@LearnatKnowstar]

Here are the examples for practicing these Date functions - 1) Find number of weekdays between two dates - Exclude Weekends kzbin.info/www/bejne/qqvJg5ewnNlkgK8 2) Find age from Birthdate kzbin.info/www/bejne/jKK2dWZrpb5sm5Y 3) Calculate biweekly Friday dates kzbin.info/www/bejne/j16lnJKdjNZ4p68 4) Find first and last day of week - method 1 kzbin.info/www/bejne/oonGkqSwrZepb5I 5) Find first and last day of week - method 2 kzbin.info/www/bejne/ZpbPdXWrhayXbK8 6) How to find number of Sundays between two dates kzbin.info/www/bejne/nHikpqKIoMaer5I 7) How to find number of Sundays in a month kzbin.info0JoZjO337tA 8) Convert date to full ordinal long format kzbin.infoJtpLMxkp6kE 9) Update only year part of the date to a constant value kzbin.infocFtJdvUx_ZM

[@Magswap]

It's crazy how much value your videos give, the explanations, and just each topic you do is so unique to everyone else on YT. Very well done 👏

[@LearnatKnowstar]

Glad you like them!

[@designanddecor8964]

Very helpful. Please keep posting.

[@LearnatKnowstar]

More to come!

[@Freakouts_and_found_Insane]

Thanks for sharing ...your all videos arel very informative 🙏

[@LearnatKnowstar]

Thanks a lot

[@AnshulMarele-gbaa]

Hi, as you are typing the function name like GetDate(), you are getting the function syntax. How to enable it in SSMS?

[@deepaliveer28]

Hello, There is one date column. I want to apply filter for that column. It would show the records of lask week dates only. How to do that. Any suggestions?

[@AlwaysBeTactful]

Please what can i do when i get this message "'DATE_PART' is not a recognized built-in function name."

[@aanchalsrivastava8550]

Can u explain nested replace with example.

[@sireeshagiddaluru4186]

How to get null values when we use datediff function?

[@shivaramkrishnameduri8012]

Thanks for making the video. Can you help me in how to get age in the firm of 30 years, 8 months, 13 days in sql. From the date of birth column. This is asked me in the previous interview

[@LearnatKnowstar]

This is a very good question. Will post the answer for everyone soon! Please keep sharing these wonderful questions!

[@hv0032113]

Thank you for the clear explanation.

[@LearnatKnowstar]

Glad it was helpful!

[@ramadevigarnepudi-xh8iu]

Hi madam I want SQL resume pls two yeras

[@LearnatKnowstar]

Will share some tips on creating resume soon.

[@nikolaybaranov2213]

I have a very stupid question: why difference in weeks between Saturday and Sunday equal 1? Week starts on Monday, Saturday and Sunday refer to the same week of the year. SQL Query: SELECT DATEDIFF (week, '2023-05-27', '2023-05-28') ,DatePart (week, '2023-05-28') ,DatePart (week, '2023-05-27') ,@@DATEFIRST Result: 1 22 22 1