Conversion
BigQuery
CAST
BigQueryMengkonversi expression ke tipe data yang ditentukan.
Tipe hasil:
Specified typeDiperbarui: 7 Jan 2026Syntax
SQL
CAST(expression AS type)Parameter
expressionanywajib
Nilai yang akan dikonversi
typetype namewajib
Target data type
Contoh Penggunaan
Type Casting
SQL
1 SELECT 2 CAST('123' AS INT64) as str_to_int, 3 CAST(3.14 AS STRING) as float_to_str, 4 CAST('2024-01-15' AS DATE) as str_to_date;
Konversi antar tipe data.
Hasil
| str_to_int | float_to_str | str_to_date |
|---|---|---|
| 123 | 3.14 | 2024-01-15 |