4D v13.4

CAST

Home

 
4D v13.4
CAST

CAST  


 

 

Command CAST

CAST (arithmetic_expression AS sql_data_type_name)

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)

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands