Thousands separator in sql with dot in bigquery

How to cast numeric type let say 30000 into string type with dot as thousand separator 30.000.

I tried to use

SELECT FORMAT("%'.0f", CAST(30000 as NUMERIC))

But the result is 30,000 not 30.000

Answer

You could just replace the , with . after formatting:

SELECT 
  REPLACE(
    FORMAT("%'.0f", CAST(30000 as NUMERIC)),
    ',',
    '.'
  )