Date & Time

LAST_DAY

Snowflake

Mengembalikan hari terakhir dari periode (bulan, minggu, tahun) yang mengandung tanggal yang diberikan.

Tipe hasil: DATE

Syntax

SQL

LAST_DAY(date_or_timestamp [, date_part])

Parameter

date_or_timestampDATE/TIMESTAMPwajib

Tanggal input

date_partVARCHARopsional

Periode: MONTH (default), WEEK, QUARTER, YEAR

Contoh Penggunaan

Last Day of Different Periods

SQL

1 SELECT
2   LAST_DAY('2024-02-15') as last_of_feb,
3   LAST_DAY('2024-02-15', 'QUARTER') as last_of_q1,
4   LAST_DAY('2024-02-15', 'YEAR') as last_of_year;

Hari terakhir dari berbagai periode.

Hasil

last_of_feb	last_of_q1	last_of_year
2024-02-29	2024-03-31	2024-12-31

Fungsi Terkait

NEXT_DAYPREVIOUS_DAYADD_MONTHSMONTHS_BETWEEN

Kembali ke Snowflake Functions

1	SELECT
2	LAST_DAY('2024-02-15') as last_of_feb,
3	LAST_DAY('2024-02-15', 'QUARTER') as last_of_q1,
4	LAST_DAY('2024-02-15', 'YEAR') as last_of_year;