Conversion

SAFE_CAST

BigQuery

Mengkonversi expression ke tipe data yang ditentukan, mengembalikan NULL jika gagal.

Tipe hasil: Specified type or NULLDiperbarui: 7 Jan 2026

Syntax

SQL

SAFE_CAST(expression AS type)

expressionanywajib

Nilai yang akan dikonversi

typetype namewajib

Target data type

SQL

1 SELECT
2   SAFE_CAST('123' AS INT64) as valid,
3   SAFE_CAST('abc' AS INT64) as invalid;

SAFE_CAST mengembalikan NULL untuk konversi invalid.

Hasil

valid	invalid
123	NULL

TRY_CAST

Snowflake

TRY_CAST

DuckDB

1	SELECT
2	SAFE_CAST('123' AS INT64) as valid,
3	SAFE_CAST('abc' AS INT64) as invalid;