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


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


Xem thêm bài viết khác:


  1. I have a question: like date is in this format 9302018 then how to convert it into 20193009 but mind it that its not only a single its for a particular column in table and it contains 1000 rows.
    Please suggest the way .

  2. Hello sir, there are 10000 records and i have them from source to taget table then how can i check whether particular target column contains valid date format ?

  3. 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?

  4. 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

  5. Just in case someone else has the same "How about other language with datename?"-function that I had: Try SET LANGUAGE, like this:
    SET LANGUAGE Finnish

    and back to English:
    SET LANGUAGE English

    Works at least with some versions of SQL Server. Worth a try I'd say.

    For a language list, try this:

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

  7. I have a suggestion for future videos since this one is almost 2 years old. You should post queries on your website or on a 3rd party website  to replicate the tables you're working with in order to make learning easier for some beginners.

  8. 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.

  9. 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

  10. 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


Please enter your comment!
Please enter your name here