DateTime functions in SQL Server Part 25

[@anuragvashishtha6660]

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

[@AnkitMishra-ni3qm]

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

[@krzysztofs8535]

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

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

[@ItsWithinYou]

Very well explained! Thank you for sharing!

[@1charaia]

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

[@sureshrajput5794]

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

[@sarahsaad4290]

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

[@darikterfa624]

You Changed my life

[@smith11drs]

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 !

[@artokilponen6989]

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.

[@ashishjain1660]

it is awesome.Tks. All of tutorial is good

[@techtalesandtravelgiggles]

thank you for the course

[@sonusidd1]

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.

[@kaushikbhadani]

very very nice explanation...

[@sudheersmart5226]

so u r living in london.great sir

[@SaurabhSarang]

2012 :)

[@kristiankanev7934]

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.

[@stutitehri993]

nice tutorial

[@apratimmazumdar1391]

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

[@kanasree123]

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

[@Notsosmart123]

At what time stamp?

[@Aphsun]

thanks

[@tharasathi3804]

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

[@merlioninfotech5787]

sir please explain timezone function in sql

[@kevintech5728]

Are you still in London

[@Notsosmart123]

Might

[@gssiautomationteam696]

nice video

[@shivarjunroy1394]

Venkat Baba rocks

[@ahmadnaru3218]

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

[@easwarapriyan9763]

any one in 2024

[@krismaly6300]

Revisiting Thanks

[@alokranjan7323]

Are you an Indian sir?

[@Ramsvlog777]

Sir how to calculate age in functions

[@pawangowda7264]

Use Date Diff with the DOB column and Get date.

[@ahmadnaru3218]

column of date

[@shivarjunroy1394]

UTC

[@aasthadave8448]

Need your help with something pls can you help

[@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?

[@Trea704]

I fuckin love you.

[@c-jay8500]

[@anoopyadavNITIAN]

boring lectures