Date & Time

AGE

DuckDB

Menghitung selisih waktu antara dua timestamp dalam format interval yang readable (tahun, bulan, hari).

Tipe hasil: INTERVALDiperbarui: 6 Jan 2026

Syntax

SQL

AGE(timestamp1, timestamp2) | AGE(timestamp)

timestamp1TIMESTAMP/DATEwajib

Timestamp akhir (atau timestamp yang dihitung dari sekarang)

timestamp2TIMESTAMP/DATEopsional

Timestamp awal. Jika tidak ada, menggunakan CURRENT_DATE

SQL

1 SELECT
2   name,
3   birth_date,
4   AGE(birth_date) as age
5 FROM employees;

Menghitung usia dari tanggal lahir sampai sekarang.

Hasil

SQL

1 SELECT
2   name,
3   join_date,
4   AGE(CURRENT_DATE, join_date) as tenure
5 FROM employees
6 ORDER BY tenure DESC;

Menghitung berapa lama karyawan sudah bekerja.

Hasil

SQL

1 SELECT
2   project_name,
3   start_date,
4   end_date,
5   AGE(end_date, start_date) as duration
6 FROM projects
7 WHERE status = 'completed';

Menghitung durasi project dari mulai sampai selesai.

Hasil

project_name	start_date	end_date	duration
Website v2	2024-01-15	2024-04-30	3 months 15 days
Mobile App	2023-06-01	2024-02-28	8 months 27 days

1	SELECT
2	name,
3	join_date,
4	AGE(CURRENT_DATE, join_date) as tenure
5	FROM employees
6	ORDER BY tenure DESC;

1	SELECT
2	project_name,
3	start_date,
4	end_date,
5	AGE(end_date, start_date) as duration
6	FROM projects
7	WHERE status = 'completed';