Manipulating Date and Time in SQL (Part 1) | Data Talks with Kat

Part 1 of the mini-series Date Manipulation in SQL. Must-known functions for manipulating dates and datetimes in SQL. Notion page comparing various SQL platforms: https://stormy-flower-38d.notion.site/7cc0ed75467647fc8c180f9dcb9d153b?v=259824d0d5004d0b837badc6064881fc 0:00 Intro 1:01 Overview of the transaction dataset 1:51 Section1: DateTime conversions. Functions used: CAST, CONVERT. 6:29 Section2: DateTime components and arithmetic. Functions used: DATEPART, DAY, DATENAME, DATEDIFF, DATEADD 9:32 Wrapping up ISO date style lookup: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Hi, I'm Kat Li. Welcome to my channel, "Data Talks with Kat," where I will share my own experience with data science and its applications. If that sounds like it could be helpful for you, please join me by subscribing to my channel. Want more data science and programming tips? Use my link to sign up to Medium and enjoy full access to all the content: https://yilistats.medium.com/membership/. You are also welcome to follow me on my Medium page @ https://yilistats.medium.com/. 📧 Business inquiries: yilistats[at]outlook[dot]com. The following are Amazon affiliate links. That means if you purchase through the links below, I will get a small % from Amazon, but there is no premium added to your purchase price. Thank you for your support :) Main Recording Camera Panasonic LUMIX G9: https://amzn.to/3eqRcTJ Portrait LUMIX G II Lens: https://amzn.to/3Qvg3mU Webcam OBSBOT 4k Meet: https://amzn.to/3qfxKMj Video Editing Laptop Legion 5 pro gen 7: https://amzn.to/3cQnVRU Green Screen: https://amzn.to/3RnXtOG #SQL #datascience #DataTalksWithKat #career