MySQL Cast

Ads
 

MySQL Cast

Here, you will learn about the MySQL CAST() function.

Here, you will learn about the MySQL CAST() function.

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:

 

 

  1. BINARY[(N)]
  2. CHAR[(N)]
  3. DATE
  4. DATETIME
  5. DECIMAL[(M[,D])]
  6. SIGNED [INTEGER]
  7. TIME
  8. UNSIGNED [INTEGER]

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:

Ads

Ads