Conversion

CAST

DuckDB

Mengkonversi nilai dari satu tipe data ke tipe data lain. Fundamental untuk type conversion di SQL.

Tipe hasil: Tipe target yang ditentukanDiperbarui: 6 Jan 2026

Syntax

SQL

CAST(value AS type) | value::type

Parameter

valueANYwajib

Nilai yang akan dikonversi

typeTYPEwajib

Tipe data target (INTEGER, VARCHAR, DATE, etc.)

Contoh Penggunaan

String ke Integer

SQL

1 SELECT CAST('123' AS INTEGER) AS num;

Mengkonversi string ke integer.

Hasil

123

Menggunakan :: Syntax

SQL

1 SELECT '2024-01-15'::DATE AS date_value;

Shorthand syntax untuk CAST.

Hasil

2024-01-15

Number ke String

SQL

1 SELECT
2   CAST(price AS VARCHAR) || ' USD' AS price_label
3 FROM products;

Konversi untuk string concatenation.

Multiple Conversions

SQL

1 SELECT
2   '100'::INTEGER AS int_val,
3   100::VARCHAR AS str_val,
4   '2024-01-15'::DATE AS date_val,
5   1.5::BIGINT AS truncated
6 FROM (SELECT 1);

Berbagai konversi dalam satu query.

Fungsi Terkait

TRY_CAST

Kembali ke DuckDB Functions

1	SELECT
2	CAST(price AS VARCHAR) \|\| ' USD' AS price_label
3	FROM products;

1	SELECT
2	'100'::INTEGER AS int_val,
3	100::VARCHAR AS str_val,
4	'2024-01-15'::DATE AS date_val,
5	1.5::BIGINT AS truncated
6	FROM (SELECT 1);