Conversion

TYPEOF

DuckDB

Mengembalikan nama tipe data dari nilai. Berguna untuk debugging dan schema inspection.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

TYPEOF(value)

Parameter

valueANYwajib

Nilai yang akan dicek tipenya

Contoh Penggunaan

Cek Tipe Literal

SQL

1 SELECT
2   TYPEOF(123) AS int_type,
3   TYPEOF('hello') AS str_type,
4   TYPEOF(1.5) AS float_type,
5   TYPEOF(true) AS bool_type;

Melihat tipe dari literal values.

Hasil

INTEGER | VARCHAR | DOUBLE | BOOLEAN

Cek Tipe Kolom

SQL

1 SELECT DISTINCT
2   TYPEOF(price) AS price_type,
3   TYPEOF(created_at) AS date_type
4 FROM products
5 LIMIT 1;

Inspect tipe data kolom.

Debug Mixed Types

SQL

1 SELECT
2   value,
3   TYPEOF(value) AS type
4 FROM json_data
5 WHERE TYPEOF(value) != 'VARCHAR';

Find non-string values.

Schema Discovery

SQL

1 SELECT
2   column_name,
3   TYPEOF(value) AS detected_type
4 FROM (
5   SELECT 'id' AS column_name, id AS value FROM products
6   UNION ALL
7   SELECT 'name', name FROM products
8   UNION ALL
9   SELECT 'price', price FROM products
10 ) t
11 GROUP BY column_name, detected_type;

Discover column types dynamically.

Fungsi Terkait

JSON_TYPEJSON_ARRAY_LENGTHJSON_KEYS

Kembali ke DuckDB Functions

1	SELECT
2	TYPEOF(123) AS int_type,
3	TYPEOF('hello') AS str_type,
4	TYPEOF(1.5) AS float_type,
5	TYPEOF(true) AS bool_type;

1	SELECT DISTINCT
2	TYPEOF(price) AS price_type,
3	TYPEOF(created_at) AS date_type
4	FROM products
5	LIMIT 1;

1	SELECT
2	value,
3	TYPEOF(value) AS type
4	FROM json_data
5	WHERE TYPEOF(value) != 'VARCHAR';

1	SELECT
2	column_name,
3	TYPEOF(value) AS detected_type
4	FROM (
5	SELECT 'id' AS column_name, id AS value FROM products
6	UNION ALL
7	SELECT 'name', name FROM products
8	UNION ALL
9	SELECT 'price', price FROM products
10	) t
11	GROUP BY column_name, detected_type;