Conversion

TRY_TO_NUMBER

Snowflake

Mencoba mengkonversi string ke NUMBER. Mengembalikan NULL jika konversi gagal, alih-alih error.

Tipe hasil: NUMBER or NULL

Syntax

SQL

TRY_TO_NUMBER(string_expr [, format] [, precision, scale])

Parameter

string_exprVARCHARwajib

String yang akan dikonversi

formatVARCHARopsional

Format string (optional)

precision, scaleINTEGERopsional

Precision dan scale untuk hasil (optional)

Contoh Penggunaan

Safe String to Number Conversion

SQL

1 SELECT
2   value_str,
3   TRY_TO_NUMBER(value_str) as converted,
4   CASE WHEN TRY_TO_NUMBER(value_str) IS NULL
5        THEN 'Invalid' ELSE 'Valid' END as status
6 FROM (
7   SELECT '123.45' as value_str UNION ALL
8   SELECT 'abc' UNION ALL
9   SELECT '999' UNION ALL
10   SELECT NULL
11 );

Konversi string ke number dengan handling invalid values.

Hasil

value_str	converted	status
123.45	123.45	Valid
abc	NULL	Invalid
999	999	Valid
NULL	NULL	Invalid

Kembali ke Snowflake Functions

1	SELECT
2	value_str,
3	TRY_TO_NUMBER(value_str) as converted,
4	CASE WHEN TRY_TO_NUMBER(value_str) IS NULL
5	THEN 'Invalid' ELSE 'Valid' END as status
6	FROM (
7	SELECT '123.45' as value_str UNION ALL
8	SELECT 'abc' UNION ALL
9	SELECT '999' UNION ALL
10	SELECT NULL
11	);