Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind MySQL CONVERT() Function?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___("2017-08-29", DATE);3Order
Put the learning moves in the order that makes the concept easiest to apply.
The CONVERT() function converts a value into the specified datatype or character set.
Definition and Usage
MySQL CONVERT() Function
Example
SELECT
CONVERT("2017-08-29", DATE);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: Value Description DATE Converts value to DATE. Format: "YYYY-MM-DD" DATETIME Converts value to DATETIME. Format: "YYYY-MM-DD HH:MM:SS" DECIMAL Converts value to DECIMAL. Use the optional M and D parameters to specify the maximum number of digits (M) and the number of digits following the decimal point (D). TIME Converts value to TIME. Format: "HH:MM:SS" CHAR Converts value to CHAR (a fixed length string) NCHAR Converts value to NCHAR (like CHAR, but produces a string with the national character set) SIGNED Converts value to SIGNED (a signed 64-bit integer) UNSIGNED Converts value to UNSIGNED (an unsigned 64-bit integer) BINARY Converts value to BINARY (a binary string) |
| Value | Description |
| DATE | Converts value to DATE. Format: "YYYY-MM-DD" |
| DATETIME | Converts value to DATETIME. Format: "YYYY-MM-DD HH:MM:SS" |
| DECIMAL | Converts value to DECIMAL. Use the optional M and D parameters to specify the maximum number of digits (M) and the number of digits following the decimal point (D). |
| TIME | Converts value to TIME. Format: "HH:MM:SS" |
| CHAR | Converts value to CHAR (a fixed length string) |
| NCHAR | Converts value to NCHAR (like CHAR, but produces a string with the national character set) |
| SIGNED | Converts value to SIGNED (a signed 64-bit integer) |
| UNSIGNED | Converts value to UNSIGNED (an unsigned 64-bit integer) |
| BINARY | Converts value to BINARY (a binary string) |
| charset | Required. The character set to convert to |
| Value | Description |
|---|---|
| DATE | Converts value to DATE. Format: "YYYY-MM-DD" |
| DATETIME | Converts value to DATETIME. Format: "YYYY-MM-DD HH:MM:SS" |
| DECIMAL | Converts value to DECIMAL. Use the optional M and D parameters to specify the maximum number of digits (M) and the number of digits following the decimal point (D). |
| TIME | Converts value to TIME. Format: "HH:MM:SS" |
| CHAR | Converts value to CHAR (a fixed length string) |
| NCHAR | Converts value to NCHAR (like CHAR, but produces a string with the national character set) |
| SIGNED | Converts value to SIGNED (a signed 64-bit integer) |
| UNSIGNED | Converts value to UNSIGNED (an unsigned 64-bit integer) |
| BINARY | Converts value to BINARY (a binary string) |
Technical Details
| Works in: | From MySQL 4.0 |
|---|