Skip to content

PRO TIP Block youtube.com at the DNS level β€” Pi-hole, NextDNS or your hosts file β€” but allow youtube-nocookie.com and i.ytimg.com. These tutorials keep playing; the rabbit hole does not.

Learning without distractions

SQL Date & Time Functions | DATEPART, DATENAME, DATETRUNC, EOMONTH | #SQL Course 15

97.1K views on YouTube

Visually explained how SQL date and time functions like DATEPART, DATENAME, DATETRUNC, and EOMONTH manage and format dates.
πŸ‘‰ Subscribe, Like, and Comment If you want more FREE Courses ❀️https://www.youtube.com/@UC8_RSKwbU1OmZWNEoLV1tQg

━━━━━

*MY COURSES*
To get certified, better clean structure & progress, support me:
πŸ…SQL https://www.datawithbaraa.com/course/sql-full-course-for-beginners
πŸ…Tableau https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners
πŸ…Udemy SQL: https://bit.ly/4hH947P
πŸ…Udemy Tableau: https://bit.ly/3xFiDDk

━━━━━

*CONNECT WITH ME*
πŸ“¬ Newsletter https://www.blog.datawithbaraa.com/subscribe
πŸ‘¨β€πŸ’» LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/
πŸ“Έ Instagram https://www.instagram.com/datawithbaraa/
πŸŽ₯ TikTok https://www.tiktok.com/@datawithbaraa
🌍 Website https://www.datawithbaraa.com/
πŸ’¬ Discord https://discord.gg/gsVJbMxKcA
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link
πŸ“© Sponsorships baraa@datawithbaraa.com

━━━━━

*Get 25%* OFF DataCamp’s Here
https://www.datacamp.com/coupon/membership-2Fcheckout-3Fcoupon-DATAWITHBARAA25ALE25

━━━━━

*MY FREE COURSES*
*SQL* https://youtu.be/SSKVgrwhzus
*Python* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZGfFl2ANI_zISzNp257Lwn
*Tableau* https://youtu.be/UcGF09Awm4Y
*Real World Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7
*Data Career Roadmaps* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd

━━━━━

🎁 *FREE DOWNLOADS & MATERIALS*
https://www.datawithbaraa.com/wiki/sql#sql-welcome

πŸ“– *Table of Content*
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

This course is perfect for data analysts, data engineers, data scientists, software developers, and studentsβ€”covering everything from the basics to advanced SQL topics.
#sql #sqlserver #data #analytics #dataanalysis #datascience