Cast Functions Operators MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Cast Functions Operators
  4. CAST(expr AS type), CONVERT(expr,type), CONVERT(expr USING transcoding_name)
The CAST() and CONVERT() functions take a value of one type and produce a value of another type.
The type can be one of the following values:
BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]
CONVERT() with USING is used to convert data between different character sets.