Conversion

TRY_CAST

Snowflake

Versi safe dari CAST - mengembalikan NULL jika konversi gagal.

Tipe hasil: Specified target type or NULLDiperbarui: 6 Jan 2026

Syntax

SQL

TRY_CAST(expression AS target_type)

Parameter

expressionanywajib

Nilai untuk dikonversi

target_typedata typewajib

Tipe data target

Contoh Penggunaan

Safe Conversion

SQL

1 SELECT TRY_CAST('not a number' AS INTEGER) as num;

Return NULL untuk invalid input.

Hasil

NULL

With Validation

SQL

1 SELECT
2   input_value,
3   TRY_CAST(input_value AS INTEGER) as parsed,
4   CASE WHEN TRY_CAST(input_value AS INTEGER) IS NULL
5        THEN 'Invalid' ELSE 'Valid' END as status
6 FROM raw_data;

Parse dengan pengecekan validitas.

Fungsi Equivalen di Database Lain

SAFE_CAST

BigQuery

TRY_CAST

DuckDB

Fungsi Terkait

CAST

Kembali ke Snowflake Functions

1	SELECT
2	input_value,
3	TRY_CAST(input_value AS INTEGER) as parsed,
4	CASE WHEN TRY_CAST(input_value AS INTEGER) IS NULL
5	THEN 'Invalid' ELSE 'Valid' END as status
6	FROM raw_data;