You are viewing the archived documentation of TiDB, which no longer receives updates.

View latest LTS version docs

Cast Functions and Operators

Cast functions and operators enable conversion of values from one data type to another. TiDB supports all of the cast functions and operators available in MySQL 5.7.

List of cast functions and operators

NameDescription
BINARYCast a string to a binary string
CAST()Cast a value as a certain type
CONVERT()Cast a value as a certain type