MySQL Cast
Here, you will learn about the MySQL CAST() function.
CAST(): This is a function same as convert() function. Both functions are used to cast a value as a certain types. The CAST() function converts a value of one type to the other type.
Syntax:
| CAST(expr AS type) |
The "type" can have the following values:
|
For example, BINARY converts a string to BINARY data type.
Table: employee
| CREATE TABLE `employee` ( `emp_id` int(11) NOT NULL auto_increment, `emp_name` varchar(100) character set utf8 NOT NULL, `emp_salary` int(11) NOT NULL, `emp_startDate` datetime NOT NULL, `dep_name` varchar(50) NOT NULL, PRIMARY KEY (`emp_id`) ) |
Data in the above table: (Using SELECT * FROM employee;)
Here, you will learn about the MySQL CAST() function.
|
SELECT CAST(emp_startDate as Date) AS StartDate FROM employee; |
Output:
