Here are the examples for practicing these Date functions - 1) Find number of weekdays between two dates - Exclude Weekends kzitem.info/news/bejne/1bCcuJiwoKZifYI 2) Find age from Birthdate kzitem.info/news/bejne/t6eJqmdrqYtqmGk 3) Calculate biweekly Friday dates kzitem.info/news/bejne/umN40ZOdkKN2pII 4) Find first and last day of week - method 1 kzitem.info/news/bejne/zY6Zx6WwsWSnbGU 5) Find first and last day of week - method 2 kzitem.info/news/bejne/kZuiqnariXmVaYI 6) How to find number of Sundays between two dates kzitem.info/news/bejne/x31326OIpJOcrGU 7) How to find number of Sundays in a month kzitem.info0JoZjO337tA 8) Convert date to full ordinal long format kzitem.infoJtpLMxkp6kE 9) Update only year part of the date to a constant value kzitem.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
10 ай бұрын
Please what can i do when i get this message "'DATE_PART' is not a recognized built-in function name."
@sireeshagiddaluru4186
Жыл бұрын
How to get null values when we use datediff function?
@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.
@aanchalsrivastava8550
Жыл бұрын
Can u explain nested replace with example.
@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!
@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
Пікірлер: 19