Oftentimes, data in columns of tables is not in the exact format we need to complete our desired analysis. We may need to extract a date from a full timestamp, manipulate a number, or combine first and last name columns to create a full name.

In this lesson, we’ll be learning about some of SQL’s built-in functions for transforming dates, numbers and strings. We’ll be using database of bakeries in this lesson.

It is important to note that date, number, and string functions are highly database dependent. Here, we focus on built-in functions in the SQLite database management system.



Select ten rows from the bakeries table.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?