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://wijstaanvooronzegrondrechten.org
Xem thêm bài viết khác: https://wijstaanvooronzegrondrechten.org/cong-nghe
<3
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 .
For SQL you are best sir.
thank you
Thanks Sir.
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 ?
Great video! as always. Thank you so much!!
Very good lessons, thank you!
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?
Thank you very much sir… Its a very good stuff
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
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
i am using select DAY(31/02/2017)
select Month(31/02/2017)
why it returns always 1??
?
#Respect your effort!
Thanks a lot for this collaboration on SQL.
Clear, Simple and Inspiring to learn more.
Print GETDATE() = Jan 16 2017 2:31PM
Greetings from Poland in 2017!
You are wonderful
You explain everything very clearly and all your videos are so helpful. Excellent!
Thank you Mr.Venkat. Your videos are the best.
sir, do you have another account because i subscribed in this account
ProgramerLanguage
thanks for your effort awesome explanation
sir your grt coz explanation is very easily understand
Revisiting
Thanks
Sir you are god
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.
awesome explanation
very very nice…..
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.
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
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
you are awesome
Than You for this video. Well explained.