JSON

LAX_FLOAT64

BigQuery

Mengkonversi JSON value ke FLOAT64 dengan konversi yang fleksibel.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

LAX_FLOAT64(json_expression)

json_expressionJSONwajib

Nilai JSON untuk dikonversi

SQL

1 SELECT
2   LAX_FLOAT64(JSON '3.14') as from_num,
3   LAX_FLOAT64(JSON '"3.14"') as from_str,
4   LAX_FLOAT64(JSON 'true') as from_bool;

Konversi fleksibel ke float.

Hasil

from_num	from_str	from_bool
3.14	3.14	1.0

1	SELECT
2	LAX_FLOAT64(JSON '3.14') as from_num,
3	LAX_FLOAT64(JSON '"3.14"') as from_str,
4	LAX_FLOAT64(JSON 'true') as from_bool;