Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Learn

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.

Report a Bug
If you see a bug or any other issue with this page, please report it here.