Type casting and conversion in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to convert the string '123' to an integer using CAST.

MySQL

SELECT CAST('123' AS [1]);

Drag options to blanks, or click blank then click option'

ASIGNED

BDECIMAL

CDATE

DCHAR

Attempts:

3 left

💡 Hint

Common Mistakes

Using CHAR instead of SIGNED causes no numeric conversion.

Using DATE or DECIMAL changes the type incorrectly.

In MySQL, to convert a string to an integer, you use CAST with AS SIGNED.

2fill in blank

medium

Complete the code to convert the integer 2023 to a string using CAST.

MySQL

SELECT CAST(2023 AS [1]);

Drag options to blanks, or click blank then click option'

ASIGNED

BDECIMAL

CDATE

DCHAR

Attempts:

3 left

💡 Hint

Common Mistakes

Using SIGNED keeps it as a number.

Using DATE or DECIMAL changes the type incorrectly.

CAST AS CHAR converts a number to a string in MySQL.

3fill in blank

hard

Fix the error in the code to convert the string '2023-06-01' to a DATE type.

MySQL

SELECT CAST('2023-06-01' AS [1]);

Drag options to blanks, or click blank then click option'

ASIGNED

BCHAR

CDATE

DDECIMAL

Attempts:

3 left

💡 Hint

Common Mistakes

Using SIGNED or DECIMAL causes conversion errors.

Using CHAR keeps it as a string.

To convert a string to a date, use CAST AS DATE in MySQL.

4fill in blank

hard

Fill both blanks to convert the string '123.45' to a decimal number with 5 digits and 2 decimals.

MySQL

SELECT CAST('123.45' AS [1]([2], 2));

Drag options to blanks, or click blank then click option'

ADECIMAL

BSIGNED

C5

D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using SIGNED instead of DECIMAL causes wrong type.

Using 10 instead of 5 changes precision.

DECIMAL(5, 2) defines a decimal number with 5 total digits and 2 decimal places.

5fill in blank

hard

Fill all three blanks to convert the string '2023-06-01 12:30:00' to a DATETIME type and alias it as 'converted'.

MySQL

SELECT CAST([1] AS [2]) AS [3];

Drag options to blanks, or click blank then click option'

A'2023-06-01 12:30:00'

BDATETIME

Cconverted

D'2023-06-01'

Attempts:

3 left

💡 Hint

Common Mistakes

Using only the date string loses time information.

Wrong alias names cause confusion.

CAST the full datetime string as DATETIME and alias the result as 'converted'.