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).