Mega Code Archive

 

Categories / MySQL / Function

 

Type Conversion (Cast)

CAST(x AS type)                Changes x into the specified type. CAST works with the following types:                                BINARY, CHAR, DATE, DATETIME, SIGNED [INTEGER], TIME, and UNSIGNED [INTEGER]. CONVERT(x, type)               Equivalent to CAST(x AS type).