How to trim and display only 4 digits / decimal places in Bigquery Numeric ?

BigQuery supports a FORMAT() function for formatting strings. This function is similar to the C printf function. It produces a STRING from a format string that contains zero or more format specifiers, along with a variable length list of additional arguments that matches the format specifiers

Select FORMAT("%.*f",2,Col_Name) from Mydataset.MyTable;

Eg:

Select Format("%.*f",2,98.30000):

Returns: 98.30

Also see:

Roundup decimals in Bigquery
Truncate decimals in Bigquery

nVector

posted on 14 May 20