MySQL CONVERT() Function
ExampleGet your own SQL Server
Convert a value to a DATE datatype:
SELECT
CONVERT("2017-08-29", DATE);
Try it Yourself »
Definition and Usage
The CONVERT() function converts a value into the specified datatype or character set.
Tip: Also look at the CAST() function.
Syntax
CONVERT(value, type)
OR:
CONVERT(value USING charset)
Parameter Values
Parameter | Description | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
value | Required. The value to convert | ||||||||||||||||||||
type | Required. The datatype to convert to. Can be one of the following:
|
||||||||||||||||||||
charset | Required. The character set to convert to |
Technical Details
Works in: | From MySQL 4.0 |
---|
More Examples
Example
Convert a value to LATIN1 character set:
SELECT
CONVERT("W3Schools.com" USING latin1);
Try it Yourself »