Date & Time

FORMAT_TIMESTAMP

BigQuery

Memformat TIMESTAMP menjadi string. Mendukung timezone untuk display yang benar.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

FORMAT_TIMESTAMP(format_string, timestamp_expression [, time_zone])

Parameter

format_stringSTRINGwajib

Format string dengan date, time, dan timezone elements

timestamp_expressionTIMESTAMPwajib

TIMESTAMP yang akan diformat

time_zoneSTRINGopsional

Timezone untuk display (default UTC)

Contoh Penggunaan

Format with Timezone

SQL

1 SELECT
2   ts,
3   FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S %Z', ts) as utc_format,
4   FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', ts, 'Asia/Jakarta') as jakarta_time
5 FROM UNNEST([TIMESTAMP '2024-01-15 10:00:00 UTC']) as ts;

Format timestamp dengan timezone berbeda.

Hasil

ts	utc_format	jakarta_time
2024-01-15 10:00:00 UTC	2024-01-15 10:00:00 UTC	2024-01-15 17:00:00

User Display

SQL

1 SELECT
2   user_id,
3   FORMAT_TIMESTAMP('%d %B %Y, %H:%M', last_login, user_timezone) as last_seen
4 FROM `project.dataset.users`;

Display waktu dalam timezone user.

Hasil

15 January 2024, 17:00

Fungsi Terkait

FORMAT_DATEFORMAT_TIME

Kembali ke BigQuery Functions

1	SELECT
2	ts,
3	FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S %Z', ts) as utc_format,
4	FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', ts, 'Asia/Jakarta') as jakarta_time
5	FROM UNNEST([TIMESTAMP '2024-01-15 10:00:00 UTC']) as ts;

1	SELECT
2	user_id,
3	FORMAT_TIMESTAMP('%d %B %Y, %H:%M', last_login, user_timezone) as last_seen
4	FROM `project.dataset.users`;