Date & Time

CURRENT_DATE

BigQuery

Mengembalikan tanggal saat ini berdasarkan timezone yang ditentukan atau default timezone.

Tipe hasil: DATEDiperbarui: 7 Jan 2026

Syntax

SQL

CURRENT_DATE([time_zone])

time_zoneSTRINGopsional

Timezone string (e.g., 'Asia/Jakarta', 'UTC')

SQL

1 SELECT
2   CURRENT_DATE() as today,
3   CURRENT_DATE('Asia/Jakarta') as today_jakarta,
4   CURRENT_DATE('America/New_York') as today_ny;

Tanggal saat ini di berbagai timezone.

Hasil

today	today_jakarta	today_ny
2024-01-15	2024-01-15	2024-01-14

SQL

1 SELECT *
2 FROM `project.dataset.orders`
3 WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY);

Filter order 7 hari terakhir.

SQL

1 SELECT
2   name,
3   birth_date,
4   DATE_DIFF(CURRENT_DATE(), birth_date, YEAR) as age
5 FROM `project.dataset.users`;

Hitung umur berdasarkan tanggal lahir.

1	SELECT
2	CURRENT_DATE() as today,
3	CURRENT_DATE('Asia/Jakarta') as today_jakarta,
4	CURRENT_DATE('America/New_York') as today_ny;

1	SELECT *
2	FROM `project.dataset.orders`
3	WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY);

1	SELECT
2	name,
3	birth_date,
4	DATE_DIFF(CURRENT_DATE(), birth_date, YEAR) as age
5	FROM `project.dataset.users`;