CONTACT US: 778-373-4422 | info@mackenziemackenzie.com


Photo by Pete Linforth from Pixabay

How to Format Dates in SQL Server

02-July-2021
Date formatting is one of the key skills you’ll learn as you progress as a data engineer. In the old days, it could be a hassle for you to get a particular format. Every country and client site seems to use a different format, and it can wreak havoc with even well-written code. For SQL Server, things have gotten better since SQL Server 2012, when a new function called “Format” started to be used alongside the traditional way of getting date formats which is a function called “Convert”. Find out these two ways of formatting your dates in this episode!



Data Engineering Project? Contact me today!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop