Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Sql Mysql-example MySQL Cast

Related Tutorials


Share on Google+Share on Google+

MySQL Cast

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.


CAST(expr AS type)

The "type" can have the following values:



  1. BINARY[(N)]
  2. CHAR[(N)]
  3. DATE
  5. DECIMAL[(M[,D])]
  7. TIME

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;



If you enjoyed this post then why not add us on Google+? Add us to your Circles

Liked it!  Share this Tutorial

Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 20, 2009

Related Tutorials

Discuss: MySQL Cast  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image