Date & Time

PREVIOUS_DAY

Snowflake

Mengembalikan tanggal dari hari tertentu yang terakhir kali muncul sebelum tanggal input.

Tipe hasil: DATE

Syntax

SQL

PREVIOUS_DAY(date_or_timestamp, day_of_week)

date_or_timestampDATE/TIMESTAMPwajib

Tanggal referensi

day_of_weekVARCHARwajib

Nama hari: 'su', 'mo', 'tu', 'we', 'th', 'fr', 'sa'

SQL

1 SELECT
2   '2024-01-15'::DATE as today,
3   PREVIOUS_DAY('2024-01-15', 'fr') as last_friday,
4   PREVIOUS_DAY('2024-01-15', 'mo') as last_monday;

Mencari Jumat dan Senin sebelumnya.

Hasil

today	last_friday	last_monday
2024-01-15	2024-01-12	2024-01-08

1	SELECT
2	'2024-01-15'::DATE as today,
3	PREVIOUS_DAY('2024-01-15', 'fr') as last_friday,
4	PREVIOUS_DAY('2024-01-15', 'mo') as last_monday;