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

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