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

Công Nghệ



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

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

Nguồn: https://bus-rush.info/

Xem thêm bài viết khác: https://bus-rush.info/cong-nghe/

25 thoughts on “IsDate, Day, Month, Year and DateName DateTime functions in SQL Server Part 26

  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
    SELECT DATENAME(MONTH, GETDATE()) AS 'MonthName'
    SELECT DATENAME(WEEKDAY, GETDATE()) AS 'DayName'

    and back to English:
    SET LANGUAGE English
    SELECT DATENAME(MONTH, GETDATE()) AS 'MonthName'
    SELECT DATENAME(WEEKDAY, GETDATE()) AS 'DayName'

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

    For a language list, try this: https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-syslanguages-transact-sql

  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.

Leave a Reply

Your email address will not be published. Required fields are marked *