Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind MySQL CAST() 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" AS DATE);3Order
Put the learning moves in the order that makes the concept easiest to apply.
The CAST() function converts a value (of any type) into the specified datatype.
Definition and Usage
MySQL CAST() Function
Example
SELECT
CAST("2017-08-29" AS DATE);Definition and Usage
The CAST() function converts a value (of any type) into the specified datatype.
Tip
See also the CONVERT() function.
Syntax
CAST(
value
AS
datatype
)Parameter Values
| Parameter | Description |
|---|---|
| value | Required. The value to convert |
| datatype | 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) |
| 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 |
|---|