MySQL cast and convert Functions

From: http://www.cnblogs.com/SandyWang/archive/2010/06/03/1750907.html

Today, we can see the cast and convert functions of MySQL. It is found that this is different from other databases.

The specific syntax of the two is as follows:

Cast (valueType); Convert (value,Type);

Not all types can be dropped. The type that can be converted is as follows:

Binary, with a binary Prefix: Binary
Character type, with parameters: Char ()
Date: Date
Time: Time
Datetime type
Floating Point: decimal
Integer: signed
Unsigned integer

 

 

The above referred to the http://todaydiy.blog.163.com/blog/static/104189687201022143812156/