Date & Time

LAST_DAY

BigQuery

Mengembalikan hari terakhir dari periode yang ditentukan (bulan, quarter, atau tahun).

Tipe hasil: DATEDiperbarui: 7 Jan 2026

Syntax

SQL

LAST_DAY(date_expression [, date_part])

date_expressionDATE/DATETIME/TIMESTAMPwajib

Tanggal input

date_partDATE_PARTopsional

MONTH, QUARTER, atau YEAR (default: MONTH)

Default: MONTH

SQL

1 SELECT
2   date,
3   LAST_DAY(date) as last_day_of_month
4 FROM UNNEST([DATE '2024-02-15', DATE '2024-06-01', DATE '2024-12-25']) as date;

Menemukan hari terakhir bulan untuk berbagai tanggal.

Hasil

SQL

1 SELECT
2   date,
3   LAST_DAY(date, QUARTER) as last_day_of_quarter
4 FROM UNNEST([DATE '2024-02-15', DATE '2024-08-01']) as date;

Hari terakhir quarter untuk perencanaan laporan.

Hasil

date	last_day_of_quarter
2024-02-15	2024-03-31
2024-08-01	2024-09-30

1	SELECT
2	date,
3	LAST_DAY(date) as last_day_of_month
4	FROM UNNEST([DATE '2024-02-15', DATE '2024-06-01', DATE '2024-12-25']) as date;

1	SELECT
2	date,
3	LAST_DAY(date, QUARTER) as last_day_of_quarter
4	FROM UNNEST([DATE '2024-02-15', DATE '2024-08-01']) as date;