SQL Date & Time Functions | Datepart, Datename, Datetrunc, Eomonth |
Data with Baraa Data with Baraa
27.4K subscribers
1,881 views
144

 Published On Aug 13, 2024

🎬 Full Advanced Course:    • How I'd Learn Advanced SQL and Why (I...  
⬇️ Free Materials (Downloads): https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE

☕ Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn:   / baraa-khatib-salkini  
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join:    / @datawithbaraa  

📚 Free Courses
✅ Tableau:    • Complete HR Tableau Project End-to-En...  
✅ Tableau Project:    • Complete HR Tableau Project End-to-En...  
✅ SQL Basics:    • SQL Tutorial for Beginners [Ultimate ...  
✅ SQL Advanced:    • How I'd Learn Advanced SQL and Why (I...  
✅ ChatGPT:    • ChatGPT Tutorial for Beginners [Ultim...  

🎓Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare

⭐ My favorite books: https://kit.co/DataWithBaraa/my-favor...
💻 My gear: https://kit.co/DataWithBaraa/my-deskt...

⏱️ 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

#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

show more

Share/Embed