Date & Time

INTERVAL

PostgreSQL

Merepresentasikan durasi waktu. Bisa ditambah/dikurangi dari tanggal dan timestamp. INTERVAL adalah tipe data dan literal, bukan fungsi.

Tipe hasil: interval

Syntax

SQL

INTERVAL quantity unit
MAKE_INTERVAL(years, months, weeks, days, hours, mins, secs)

quantitynumericwajib

Jumlah unit waktu

unittextwajib

Unit: year, month, week, day, hour, minute, second

SQL

1 SELECT 
2   INTERVAL 1 year,
3   INTERVAL 3 months,
4   INTERVAL 2 weeks 3 days;

Berbagai cara menulis interval.

Hasil

interval	interval	interval
1 year	3 mons	17 days

SQL

1 SELECT 
2   CURRENT_DATE AS today,
3   CURRENT_DATE + INTERVAL 7 days AS next_week,
4   CURRENT_DATE - INTERVAL 1 month AS last_month;

Menambah dan mengurangi interval dari tanggal.

Hasil

today	next_week	last_month
2024-01-15	2024-01-22	2023-12-15

SQL

1 SELECT *
2 FROM orders
3 WHERE order_date >= NOW() - INTERVAL 30 days;

Mencari order dalam 30 hari terakhir.

SQL

1 SELECT MAKE_INTERVAL(years => 1, months => 6);

Membuat interval dengan named parameters.

Hasil

make_interval
1 year 6 mons

1	SELECT
2	CURRENT_DATE AS today,
3	CURRENT_DATE + INTERVAL 7 days AS next_week,
4	CURRENT_DATE - INTERVAL 1 month AS last_month;

1	SELECT *
2	FROM orders
3	WHERE order_date >= NOW() - INTERVAL 30 days;