Data Type Mismatches: How a Lazy Cast Crashed Reporting
Lazy Casting Is putting your career on hold and causing distrust with your stakeholders.
Confused about when to use CAST or CONVERT in SQL? In this video, we'll dive into the differences between these two powerful functions and show you how to use them to keep your data clean, consistent, and high quality. Whether you're trying to convert data types or format dates, knowing which function to use can make all the difference in your SQL queries.
You'll learn:
How CAST works across multiple databases like MySQL, PostgreSQL, and SQL Server
When and why to use SQL Server's CONVERT for data formatting
Real-world examples of CAST vs CONVERT in action
Stay tuned to become a Data Quality Champion!
Microsoft documentation on CONVERT: https://bit.ly/47JGkrz
Join the Gambill Data Sphere: https://www.gambilldataengineering.co...
Don't forget to like, subscribe, and comment on what SQL function you'd like us to cover next!
**Connect with Me**
/ gambilldataengineering
/ thegambill
/ databasemanagement
/ chris.gambill
Looking for more business related data content -
Businesses:
Reach out for a free consultation https://gambilldataengineering.com/co...
Learn more about starting your business's data journey: https://www.gambilldataengineering.co...
Individuals looking to learn more:
https://www.gambilldataengineering.co...
The NEW Data Roadmap:
https://www.gambilldataengineering.co...
CAST vs CONVERT Chapters:
00:00 Data Cleaning with Gambill Data Engineering
00:21 Who am I?
00:45 What is ANSI?
01:30 Quiz 1: Which one is ANSI Standard (Comment Below!)
02:59 CAST Syntax
04:10 Convert explanation
05:55 Convert syntax
06:20 CAST vs CONVERT which should I use?
07:23 Which one do you use? What other options do you know of? Comment Below!
08:03 Real world example in Azure Data Studio!
10:43 Data format options with Convert
13:40 2 vs 4 digit year formating
14:38 When to use CAST vs Convert
15:17 Convert non date use cases
15:30 Thank you to the community!
*** Affiliate links to great Data Engineering Books ****
Becoming a Data Head: https://amzn.to/4ebBzdb
Data Storytelling Cards: https://amzn.to/3VJVIjD
**Connect with Me**
/ gambilldataengineering
/ thegambill
/ databasemanagement
/ chris.gambill
Codecademy: 50% off :
https://www.codecademy.com/checkout?p...
Plurasight:
https://www.pluralsight.com/pricing
What Matters Most:
https://amzn.to/3ASittW
54% off right now
Data Governance:
https://amzn.to/48ZUlCl
Data Warehouse Toolkit:
https://amzn.to/3Z1o2hx
32% off right now
Studio Beats Earbuds:
https://amzn.to/496LdvO
44% off! To support the channel:
https://buymeacoffee.com/gambilldata