Tag: mysql convert string to datetime

Example

Convert a value to a DATE datatype:

SELECT CONVERT("2017-08-29", DATE);

Definition and Usage

The CONVERT() function converts a value into the specified datatype or character set.

Syntax

CONVERT(value, type)

OR:

CONVERT(value USING charset)

Continue reading MySQL CONVERT Function