`CAST` (string `AS` format).
Possible formats are
In our dataset the revenue for each account company is stored as a decimal value. If we wanted to see the value as an integer we could run the query:
SELECT account, CAST(revenue AS INTEGER) FROM accounts
The results would be:
Exercises (Continued from previous section)
The exercises below can be run from the “Try query” link below, but they cannot be saved. If you would like to save your queries, see this article for instructions. You can also do the exercises from a complete stand-alone tutorial located here.
Write a query using the patient, description, and value columns from the observations table to return all the body height measurements for the patients in decimal form.
SELECT the columns
An introduction to working with strings.