MySQL CAST Function Explained

1 year ago
Sophia Anderson
1 minute

The CAST() function in MySQL is used to convert a value to a specified data type. The syntax is as follows:

CAST(expression AS data_type)

In this case, expression refers to the value to be converted, and data_type refers to the data type that it should be converted to. For example, to convert a string to an integer type, you can use the following statement:

SELECT CAST('123' AS UNSIGNED);

This will return the integer value 123. The CAST() function supports converting values into various data types, including integers, floats, dates, times, etc.

bannerAds