String

FORMAT

BigQuery

Memformat nilai menjadi string berdasarkan format string (mirip printf). Mendukung berbagai format specifiers.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

FORMAT(format_string, ...)

format_stringSTRINGwajib

Format string dengan specifiers (%s, %d, %f, dll)

...ANYwajib

Nilai-nilai yang akan diformat

SQL

1 SELECT
2   FORMAT('Hello %s, you have %d messages', 'John', 5) as greeting;

Format string dengan substitusi.

Hasil

Hello John, you have 5 messages

SQL

1 SELECT
2   FORMAT('%,.2f', 1234567.891) as formatted_number,
3   FORMAT('%010d', 42) as padded_number,
4   FORMAT('%.2f%%', 75.5) as percentage;

Format angka dengan berbagai opsi.

Hasil

formatted_number	padded_number	percentage
1,234,567.89	0000000042	75.50%

SQL

1 SELECT
2   FORMAT('%t', DATE '2024-01-15') as date_str,
3   FORMAT('%T', [1, 2, 3]) as array_literal;

Format dengan type awareness.

Hasil

date_str	array_literal
2024-01-15	[1, 2, 3]

1	SELECT
2	FORMAT('Hello %s, you have %d messages', 'John', 5) as greeting;