Date & Time

FORMAT_DATE

BigQuery

Memformat DATE menjadi string berdasarkan format yang ditentukan. Menggunakan format elements standar.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

FORMAT_DATE(format_string, date_expression)

Parameter

format_stringSTRINGwajib

Format string dengan elements seperti %Y, %m, %d

date_expressionDATEwajib

DATE yang akan diformat

Contoh Penggunaan

Common Formats

SQL

1 SELECT
2   date,
3   FORMAT_DATE('%Y-%m-%d', date) as iso_format,
4   FORMAT_DATE('%d/%m/%Y', date) as indo_format,
5   FORMAT_DATE('%B %d, %Y', date) as long_format
6 FROM UNNEST([DATE '2024-01-15']) as date;

Format tanggal dengan berbagai format.

Hasil

date	iso_format	indo_format	long_format
2024-01-15	2024-01-15	15/01/2024	January 15, 2024

Week and Day Names

SQL

1 SELECT
2   FORMAT_DATE('%A, %d %B %Y', CURRENT_DATE()) as full_date,
3   FORMAT_DATE('%a, %d %b', CURRENT_DATE()) as short_date;

Format dengan nama hari dan bulan.

Hasil

full_date	short_date
Monday, 15 January 2024	Mon, 15 Jan

Report Headers

SQL

1 SELECT
2   FORMAT_DATE('Report for %B %Y', report_date) as header
3 FROM `project.dataset.reports`;

Generate report header text.

Hasil

Report for January 2024

Fungsi Equivalen di Database Lain

TO_CHAR

PostgreSQL

DATE_FORMAT

MySQL

TO_CHAR

Snowflake

STRFTIME

DuckDB

Fungsi Terkait

FORMAT_TIMEFORMAT_TIMESTAMP

Kembali ke BigQuery Functions

1	SELECT
2	date,
3	FORMAT_DATE('%Y-%m-%d', date) as iso_format,
4	FORMAT_DATE('%d/%m/%Y', date) as indo_format,
5	FORMAT_DATE('%B %d, %Y', date) as long_format
6	FROM UNNEST([DATE '2024-01-15']) as date;

1	SELECT
2	FORMAT_DATE('%A, %d %B %Y', CURRENT_DATE()) as full_date,
3	FORMAT_DATE('%a, %d %b', CURRENT_DATE()) as short_date;

1	SELECT
2	FORMAT_DATE('Report for %B %Y', report_date) as header
3	FROM `project.dataset.reports`;