format

format(X, format)

X is a scalar/vector.

format is a string indicating the format to be applied to X. Depending on the data type of input X, format calls either function decimalFormat or temporalFormat.

Apply a specified format to the given object.

Return value: a STRING scalar/vector.

t = table(1..100 as id, (1..100 + 2018.01.01) as date, rand(100.0, 100) as price, rand(10000, 100) as qty);
t;

select id, date.format("MM/dd/yyyy") as date, price.format("00.00") as price, qty.format("#,###") as qty from t;