SQL tutorial | Date Functions | Difference between DATEDIFF and DATEADD 

Here are the examples for practicing these Date functions - 1) Find number of weekdays between two dates - Exclude Weekends ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tzfRdzgt1JM.html 2) Find age from Birthdate ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VqSD35pY9e4.html 3) Calculate biweekly Friday dates ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y-Bk_gWqEqM.html 4) Find first and last day of week - method 1 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lXcaqzx2v90.html 5) Find first and last day of week - method 2 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0elDBuPGd6M.html 6) How to find number of Sundays between two dates ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fGAuoRkaky0.html 7) How to find number of Sundays in a month ru-vid.com0JoZjO337tA 8) Convert date to full ordinal long format ru-vid.comJtpLMxkp6kE 9) Update only year part of the date to a constant value ru-vid.comcFtJdvUx_ZM

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 👏

Very helpful. Please keep posting.

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

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

Can u explain nested replace with example.

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?

How to get null values when we use datediff function?

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

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

Thank you for the clear explanation.

Hi madam I want SQL resume pls two yeras

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