MySQL CAST Function
Example Convert a value to a DATE datatype: SELECT CAST(“2017-08-29” AS DATE); Definition and Usage The CAST() function converts a value (of any type) into the specified datatype. Syntax CAST(value AS datatype)
Example Convert a value to a DATE datatype: SELECT CAST(“2017-08-29” AS DATE); Definition and Usage The CAST() function converts a value (of any type) into the specified datatype. Syntax CAST(value AS datatype)