SQL Date & Time Functions | Datepart, Datename, Datetrunc, Eomonth |

[@DataWithBaraa]

If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE ⏱ Timestamp 00:00 Intro 00:22 What is Date, Time, Timestamp? 03:57 Date & Time Values 06:28 Overview Date & Time Functions 09:07 DAY(), MONTH(), YEAR() 12:07 DATEPART() 18:00 DATENAME() 22:34 DATETRUNC() 30:45 EOMONTH() 34:16 Use Case: Data Aggregation 37:36 Use Case: Filtering Data 39:20 Functions Comparison 41:11 All Date Parts Enjoy !

[@relaxationecho3244]

I would like to thank you, Baraa, for this amazing course. I have been taking a lot of SQL courses for the past two years, but your curse is definitely the best one that I have watched.

[@DataWithBaraa]

I am really glad you liked it, thanks for the nice feedback ❤️

[@MarcosMartínezGascón]

Best SQL tutorial series ever. Thanks Baraa, you're the MAN.

[@vamc4375]

POWER BI like button👍

[@letsdomistakes]

Thank you Baraa for making such amazing content, Today I have completed this tutorial with practice and notes making.

[@DataWithBaraa]

Wonderful!

[@OJASIYER]

Best videos on SQL I have come across! Thank you so much Baraa!

[@DataWithBaraa]

Thanks dear, glad to hear that !

[@govardhanreddy690]

thank you Sir

[@pavansaibhyri412]

Thank you so much for your exceptional SQL tutorials! Your clear explanations and well-organized presentation made complex topics easy to understand. I also appreciate your impressive video editing skills; the way you present the screen is very effective. If possible, I would love to see more content from you, especially tutorials on Python. Your teaching style would be incredibly helpful for learning Python as well. Thanks again for all your hard work!

[@guiltycrown6024]

i feel like your yt channel might go big in the future..there is no content like this on any platform afaik not udemy, not a website..this is too good.. if this was a stock id have invested huge in this.. i just hope more people come to appreciate your amazing work and as always Thank you..

[@Musical_Island39]

I feel the same way. Thanks for expressing my feelings so well.

[@RohitKumar-kd5fj]

You're making really great videos! Keep working hard on the concepts, and the views and subscribers will follow. Stay focused and keep up the good work!

[@joyotiegbe1549]

Thanks Baraa.

[@reemkhaled1334]

great content thank you very much

[@imamkhan9564]

Brother, thankyou lot but please, upload cte and subquries quickly.

[@DataWithBaraa]

In the next chapters, i am doing my best :)

[@gauravbharti9676]

@@DataWithBaraa yes baraa, if you could upload the lessons in shorter span of time, it would be much beneficial. We know you might be busy with your job and then making and editing the content too takes time. However, we appreciate the way you teach. You'are one of the best teacher and your lessons are top notch. A big Thankyou..

[@imamkhan9564]

❤​@@DataWithBaraa

[@nitinrawat-g6t]

thanks

[@ofuezuemlynus2965]

Baraa the Data Guru. Thanks a lots

[@DataWithBaraa]

You are welcome :)

[@omkale9]

Grand level editing

[@DataWithBaraa]

😏

[@CuocSongQuanhTa204]

Thanks for your amazing video! Could you please share the way you approach a huge dataset? I am sometimes overwhelmed with it and got lost with a table with 60 columns or more. Thanks

[@user-wc1wu3ls9d]

Thankyou so much sir

[@nitinrawat-g6t]

thanks baraa

[@DataWithBaraa]

You are welcome !

[@kumargupta7149]

Great❤

[@DataWithBaraa]

@@kumargupta7149 ❤️

[@poddytalks]

nice

[@DataWithBaraa]

Thanks

[@micaelzekarias1537]

Wooow thanks

[@DataWithBaraa]

Welcome !

[@rajshekar1362]

THANQ FOR THIS VIDEO💓💓

[@rajshekar1362]

Hi Baraa ,please make video on CTE AND ADVANCE JOINS TOPICS

[@WrestleLane]

Please make power bi videos like this

[@alieut.k.wolobah2515]

❤❤❤❤

[@DataWithBaraa]

❤️❤️❤️❤️❤️

[@AmitYadav-vb5bs]

When will you make the video CTE Topic please bring it fast I am waiting from many videos. I was following your all videos from the SQL playlist. Can you provide us Question bank which help us with interview preparation and when will you upload the SQL Project.

[@DataWithBaraa]

Hi, CTE are coming in the next chapters, working on it !

[@makarsh29]

hey baraa , what is alternative of datetrunc() and EOMONTH() in mysql ???

[@DataWithBaraa]

In MySQL, there are no direct equivalents to DATETRUNC() but you can get the same effect if you use DATE_FORMAT(your_date_column, '%Y-%m-01'). And for the EOMONTH there is function in MYSQL called LAST_DAY()

[@GOLIBHAGYALAKSHMIBhagi]

Sir If you possible please Mack Power BI Classes like Tableau Desktop ........I will wait to Learn power BI Full Course

[@Toyahan43]

Hey Baraa, are the notes going to be available for these tutorials?

[@gauravbharti9676]

Which software do you use to record your webcam and screen simultaneously.

[@1wasim.akram2]

Please make it on Power bi

[@yashsojitra2653]

I think the presentations and notes of advance sql are not availaible in your website. If I am clicking on it its showing to documentation of downloading sql server management. Pls look into this.

[@DataWithBaraa]

If you scroll down in the same page you will find for each chapter there is like section, i have added for this chapter the SQL scripts.

[@yashsojitra2653]

@@DataWithBaraa yes, definitely..but clicking on that only is showing up the 'download sql server management studios' . I am clicking on ch 4 - case statements > Presentation bur it's opening like I have mentioned above

[@GOLIBHAGYALAKSHMIBhagi]

Sir please mack SQL sub query,CTE, View's,Temp Table Clases

[@bashadude]

How will round timestamp nearest 5 minutes interval, and aggregate data accordingly. Expected 5 minutes data instead of every minute

[@frederickagbenohevi1143]

I keep getting an error with the DATENAME & DATEPART function. What am I doing wrong?

[@GOLIBHAGYALAKSHMIBhagi]

I am Waiting for remaining SQl Classes

[@asrithagudla4865]

thank you

[@asrithagudla4865]

hi bara i have a question when ever u are writing a subquery u are writing letter t after the closing bracket of select statement can i know why?

[@fredrickmatonange1345]

Thank you

[@DataWithBaraa]

welcome !