Tag: mysql function convert string to number

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)

Continue reading MySQL CAST Function