HiRDB database supports CAST function. SQLWays leaves it as is. Data type is converted based on data type's conversion rules.

Oracle:

SELECT CAST(col1 as NUMBER) FROM t;

HiRDB:

SELECT CAST(col1 as FLOAT) FROM t; 

References in Wiki