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?
@AlwaysBeTactful11 ай бұрын
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