DateTime functions in SQL Server Part 25

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

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

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

[anuragvashishtha]

I work for Aviation industry. The date-time functions, and the UTC concept explained here greatly helps me. Thank you.

[charaia]

The BEST I ever came across on YouTube! Thank you Venkat!

[AnkitMishra-niqm]

you are one of the best teacher in India, love the way you teach...thanks alot

[krzysztofs]

Yes, it was needed. Each video of your collection is needed and perfect! Thank's for it SQL training.

[ItsWithinYou]

Very well explained! Thank you for sharing!

[sureshrajput]

worth to watch
totally outstanding kudos to u sir
u r making developers life one step ahead
u r my best tutor :)

[ashishjain]

it is awesome.Tks. All of tutorial is good

[smithdrs]

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 ! 

[sonusidd]

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.

[artokilponen]

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.

[sarahsaad]

Just wanted to thank you for your tutorial. I've been learning a lot from you. Thanks!

[kanasree]

sir, what 7 indicates in [time](7) ?
Nice Explanation!:)

[merlioninfotech]

sir please explain timezone function in sql

[kristiankanev]

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.

[tharasathi]

In a table i have two columns name and date of birth.how can we find the date of birth is todays date?kindly help me out

[apratimmazumdar]

if you are venkat, why is the channels name "kud"venkat. Just Curious xD

[aasthadave]

Need your help with something pls can you help

[ahmadnaru]

if we left column null it always show 1900-01-01

[Csharp-video-tutorialsBlogspot]

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.

[JNET_Reloaded]

how do i select all records that have an event datetime witin 1 hour before, for example mysql select all that time_diff less than 1 hour from datetime? its for a reminder email i want to make on a cronjob can you help with this sql query?