Starting from:
$30

$24

Chapter 8 How to work with data types Solution

Exercises







Write a SELECT statement that returns these columns from the Products table: The list_price column
A column that uses the FORMAT function to return the list_price column with 1 digit to the right of the decimal point




A column that uses the CONVERT function to return the list_price column as an integer




A column that uses the CAST function to return the list_price column as an integer




Write a SELECT statement that returns these columns from the Products table: The date_added column



A column that uses the CAST function to return the date_added column with its date only (year, month, and day)




A column that uses the CAST function to return the date_added column with just the year and the month




A column that uses the CAST function to return the date_added column with its full time only (hour, minutes, and seconds)

More products