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:

BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL[(M[,D])]
SIGNED [INTEGER]
TIME
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:

Related Tags for MySQL Cast:
sql, mysql, c, function, fun, io, cast, cas, unc, learn, ast, ear, e, il, as, m, out, ca, func, s, my, ll, ea, ar, s, s, th, st, ab, on, o

«Previous Index Next»