IsDate, Day, Month, Year and DateName DateTime functions in SQL Server Part 26

In this video we will learn about built-in date and time functions in sql server, specifically IsDate, Day, Month, Year and DateName functions. Finally a practical example of using these DateTime functions.

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[drip]

it's amazing how he spent his time making such amazing videos. I mean he is literally teaching everything about SQL. EVERYTHING.

[lebza_teza]

I've watched almost all your videos you have posted here and I must say... dude you are AWESOME this videos have helped me a lot great work

[loading.m]

You explain everything very clearly and all your videos are so helpful. Excellent!

[ishankhobare]

#Respect your effort!
Thanks a lot for this collaboration on SQL.
Clear, Simple and Inspiring to learn more.

[saumyaaggarwal]

Your "Hello" is even unique.

[tejakaranam]

sir your grt coz explanation is very easily understand

[venkateshkannan]

Thank you Mr.Venkat. Your videos are the best.

[KhalidAfridi]

Thanks!!! You are genious. Saving our time and efforts by giving your valuable time and awesome teaching technique to learn and boost our skills. Thanks

[ynbmtpo]

Hello Kudventak
your videos still relevant
amazing bro hatoff to you
Thank you

[sachinsoma]

This was recorded 10 years back, amazing

[hanytohamy]

thanks for your effort awesome explanation

[noquierooooo]

Great video! as always. Thank you so much!!

[seniortaco]

Than You for this video. Well explained.

[NaveenKumar-lhxi]

Thank you very much sir... Its a very good stuff

[ramavishnu]

Sir can you please show how to create table for name dob dayname month name monthnumber and year I humbly request you sir please

Starting from the syntax of sql please show me how to create table for day dob month name and number year

[sumathi]

hi sir your videos are use full for learning plz give the answer for this question
display the no. of customers registered in 2 nd quarter of the year

[bhargavtej]

For same scenario in snowflake which function i need to use

[Trzbne]

The mentioned MSDN is Microsoft Developer Network, where you can find official documentation of MS technologies, sometimes it is confusing and a bit kind of labyrinth, but sometimes it is a really big help. There is also Channel 9, videos about Microsoft technologies, but honestly... Venkat is so much better, why would we watch Channel 9?

[AkshayKumar-rebf]

hi bro, I didn't understood, how you created the column, because using only one query, in all the columns as per the data type, the data got filled. somewhat confusion in the table creation and the query used to fill the first row data in the 25th(previous) video