Date & Time

FORMAT_TIME

BigQuery

Memformat TIME menjadi string berdasarkan format yang ditentukan.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

FORMAT_TIME(format_string, time_expression)

Parameter

format_stringSTRINGwajib

Format string dengan elements seperti %H, %M, %S

time_expressionTIMEwajib

TIME yang akan diformat

Contoh Penggunaan

Common Time Formats

SQL

1 SELECT
2   time,
3   FORMAT_TIME('%H:%M:%S', time) as time_24h,
4   FORMAT_TIME('%I:%M %p', time) as time_12h,
5   FORMAT_TIME('%H.%M', time) as compact
6 FROM UNNEST([TIME '14:30:45']) as time;

Format waktu dengan berbagai format.

Hasil

time	time_24h	time_12h	compact
14:30:45	14:30:45	02:30 PM	14.30

Display Schedule

SQL

1 SELECT
2   event_name,
3   FORMAT_TIME('%H:%M', start_time) as starts,
4   FORMAT_TIME('%H:%M', end_time) as ends
5 FROM `project.dataset.schedule`;

Format jadwal acara.

Fungsi Terkait

FORMAT_DATEFORMAT_TIMESTAMP

Kembali ke BigQuery Functions

1	SELECT
2	time,
3	FORMAT_TIME('%H:%M:%S', time) as time_24h,
4	FORMAT_TIME('%I:%M %p', time) as time_12h,
5	FORMAT_TIME('%H.%M', time) as compact
6	FROM UNNEST([TIME '14:30:45']) as time;

1	SELECT
2	event_name,
3	FORMAT_TIME('%H:%M', start_time) as starts,
4	FORMAT_TIME('%H:%M', end_time) as ends
5	FROM `project.dataset.schedule`;