Date & Time

DATE

Q: Apa saja parameter fungsi DATE?

Semua 6 parameter bersifat opsional. Parameter yang digunakan: year (INT64, opsional): Year (1–9999).; month (INT64, opsional): Month (1–12).; day (INT64, opsional): Day (1–31).; timestamp_expression (TIMESTAMP, opsional): A timestamp from which to extract the date.; datetime_expression (DATETIME, opsional): A datetime from which to extract the date.; time_zone (STRING, opsional): Timezone for converting a timestamp to a date..

BigQuery

Creates a DATE value from individual components, or extracts a DATE from a timestamp or datetime expression.

Tipe hasil: DATEDiperbarui: 13 Jun 2026

Syntax

SQL

DATE(year, month, day) | DATE(timestamp_expression [, time_zone]) | DATE(datetime_expression)

Parameter

yearINT64opsional

Year (1–9999).

monthINT64opsional

Month (1–12).

dayINT64opsional

Day (1–31).

timestamp_expressionTIMESTAMPopsional

A timestamp from which to extract the date.

datetime_expressionDATETIMEopsional

A datetime from which to extract the date.

time_zoneSTRINGopsional

Timezone for converting a timestamp to a date.

Contoh Penggunaan

Create Date from Components

SQL

1 SELECT
2   DATE(2024, 1, 15) as from_parts,
3   DATE(2024, 12, 31) as year_end;

Create a DATE value from year, month, and day components.

Hasil

from_parts	year_end
2024-01-15	2024-12-31

Extract from Timestamp

SQL

1 SELECT
2   ts,
3   DATE(ts) as date_utc,
4   DATE(ts, 'Asia/Jakarta') as date_jakarta
5 FROM UNNEST([TIMESTAMP '2024-01-15 20:00:00 UTC']) as ts;

Extract a DATE from a timestamp with timezone adjustment.

Hasil

ts	date_utc	date_jakarta
2024-01-15 20:00:00 UTC	2024-01-15	2024-01-16

Parse String to Date

SQL

1 SELECT
2   DATE('2024-01-15') as parsed_date;

Parse an ISO-formatted string into a DATE value.

Hasil

2024-01-15

Pertanyaan Umum tentang DATE

Apa itu fungsi DATE di BigQuery?

Creates a DATE value from individual components, or extracts a DATE from a timestamp or datetime expression. Di BigQuery, fungsi DATE termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan DATE di BigQuery?

Gunakan sintaks berikut: DATE(year, month, day) | DATE(timestamp_expression [, time_zone]) | DATE(datetime_expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi DATE?

Fungsi DATE mengembalikan nilai bertipe DATE. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Ngulik Langsung

Sudah paham DATE? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	DATE(2024, 1, 15) as from_parts,
3	DATE(2024, 12, 31) as year_end;

1	SELECT
2	ts,
3	DATE(ts) as date_utc,
4	DATE(ts, 'Asia/Jakarta') as date_jakarta
5	FROM UNNEST([TIMESTAMP '2024-01-15 20:00:00 UTC']) as ts;