Date & Time

DATEDIFF

MySQL

Menghitung selisih hari antara dua tanggal. Mengembalikan date1 - date2 dalam hari.

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

DATEDIFF(date1, date2)

date1datewajib

Tanggal pertama

date2datewajib

Tanggal kedua

SQL

1 SELECT DATEDIFF('2024-01-31', '2024-01-01') AS diff;

Menghitung jumlah hari antara dua tanggal.

Hasil

diff: 30

SQL

1 SELECT username,
2   DATEDIFF(CURDATE(), created_at) AS age_days
3 FROM users;

Menghitung umur akun dalam hari.

Hasil

(users with account age)

SQL

1 SELECT * FROM tasks
2 WHERE DATEDIFF(CURDATE(), due_date) > 0;

Mencari task yang sudah lewat deadline.

Hasil

(overdue tasks)

DATEDIFF

Snowflake

DATE_DIFF

DuckDB

1	SELECT username,
2	DATEDIFF(CURDATE(), created_at) AS age_days
3	FROM users;

1	SELECT * FROM tasks
2	WHERE DATEDIFF(CURDATE(), due_date) > 0;