|
|
|
|
|
|
|
|
|
|
version 11
CAST (arithmetic_expression AS sql_data_type_name)
Description
The CAST function converts the arithmetic_expression to the sql_data_type_name passed following the AS keyword.
Example
This example converts the year of the movie into an Integer type:
SELECT Year_of_Movie, Title, Director, Media, Sold_Tickets
FROM MOVIES
WHERE Year_of_Movie >= CAST('1960' AS INT)
|
|
|
|
|
|
|
|
|
|