Date & Time

TIMESTAMPDIFF

MySQL

Menghitung selisih antara dua datetime dalam unit tertentu. Lebih fleksibel dari DATEDIFF.

Tipe hasil: BIGINTDiperbarui: 7 Jan 2026

Syntax

SQL

TIMESTAMPDIFF(unit, datetime1, datetime2)

unitkeywordwajib

Unit hasil (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, dll)

datetime1DATETIMEwajib

Datetime pertama (dikurangi dari datetime2)

datetime2DATETIMEwajib

Datetime kedua

SQL

1 SELECT TIMESTAMPDIFF(YEAR, '1990-05-15', CURDATE()) AS age;

Menghitung umur dalam tahun.

Hasil

age: 34

SQL

1 SELECT TIMESTAMPDIFF(HOUR, '2024-01-01 00:00:00', '2024-01-02 12:00:00') AS hours;

Selisih dalam jam.

Hasil

hours: 36

SQL

1 SELECT order_id,
2        TIMESTAMPDIFF(DAY, order_date, NOW()) AS days_ago
3 FROM orders;

Berapa hari sejak order.

Hasil

(days since each order)

TIMESTAMPDIFF

Snowflake

1	SELECT order_id,
2	TIMESTAMPDIFF(DAY, order_date, NOW()) AS days_ago
3	FROM orders;