HomeОбразованиеRelated VideosMore From: kudvenkat

DateTime functions in SQL Server Part 25

464 ratings | 200554 views
In this video we will learn about different DateTime data types, and different date time functions in sql server. We will also understand the difference between terms UTC (Coordinated Universal Time) and Time Zone offset. Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/09/datetime-functions-in-sql-server-part-25.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-25-datetime-functions-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Html code for embedding videos on your blog
Text Comments (29)
Ahmad Naru (19 days ago)
column of date
Ahmad Naru (19 days ago)
if we left column null it always show 1900-01-01
seethaRAM Kothapalli (2 months ago)
Sir how to calculate age in functions
Sarah Saad (7 months ago)
Just wanted to thank you for your tutorial. I've been learning a lot from you. Thanks!
Merlion Infotech (7 months ago)
sir please explain timezone function in sql
aphsun (8 months ago)
thanks
SALMA ALAIOUD (1 year ago)
UTC Casablanca Vive Le Maroc Lol
gssi automationteam (1 year ago)
nice video
Arto Kilponen (1 year ago)
If someone wants quick explanation of why UTC, not CUT: UTC favors neither English nor French. Also, UTC is not GMT, because UTC is not an actual timezone.
suresh rajput (1 year ago)
worth to watch totally outstanding kudos to u sir u r making developers life one step ahead u r my best tutor :)
Ashish Jain (1 year ago)
it is awesome.Tks. All of tutorial is good
Krzysztof S (2 years ago)
Yes, it was needed. Each video of your collection is needed and perfect! Thank's for it SQL training.
Kevin Tech (2 years ago)
Are you still in London
Kris Kunev (2 years ago)
Hello, can u help me with one exercise. I have table with many dates. I need to pick this records which month and year is the same as the Min Date. I hope u will help me, thank u.
Sudheer smart (2 years ago)
so u r living in london.great sir
Saurabh Sarang (2 years ago)
2012 :)
Kris Maly (3 years ago)
Revisiting  Thanks
Sayed Ali (4 years ago)
best to watch video on speed 2.  
Pradeep P (1 year ago)
exactly even i can understand his lecture in 2x speed awesome
Mahernoz Daruwala (4 years ago)
Nice idea Sayed.
#Stuti# #Tehri# (4 years ago)
nice tutorial
smith11drs (4 years ago)
Hello Venkat. I am using SQL server 2005 and i don't know where to find data types like: date(7), datetimeoffset(7), as you used. Most of functions, doesn't work for me.Any suggestions ? PS: you doing a great job ! 
Kaushik Bhadani (5 years ago)
very very nice explanation...
ThinkNext_ (5 years ago)
sir,what 7 indicates in [time](7) ? Nice Explanation!:)
sonu sidd (5 years ago)
that was an enlightening session. i have a problem. i am using sql server 2005. and it is giving me most of the data types as datetime or smalldatetime. some of the functions are also not working for me. mine is windows vista which is not showing me utc time as well. any suggestion. Thanks.
kudvenkat (5 years ago)
Thank you very much for taking time to give feedback. For email alerts, when new videos are uploaded, please subscribe to my channel. 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.
1charaia (5 years ago)
The BEST I ever came across on YouTube! Thank you Venkat!
Anurag Vashishtha (5 years ago)
I work for Aviation industry. The date-time functions, and the UTC concept explained here greatly helps me. Thank you.
Syed Najmuddin Syed (6 years ago)
Great Video....

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.