hplsql/src/test/queries/local/cast2.sql

temp_int     = CAST('1' AS int);
print temp_int
temp_float   = CAST('1.2' AS float);
print temp_float
temp_double  = CAST('1.2' AS double);
print temp_double
temp_decimal = CAST('1.2' AS decimal(10, 4));
print temp_decimal
temp_string = CAST('1.2' AS string);
print temp_string