Date & Time
MySQL
TIMESTAMPDIFF
MySQLCalculates the difference between two datetime values in a specified unit. More flexible than DATEDIFF.
Tipe hasil:
BIGINTDiperbarui: 13 Jun 2026Syntax
SQL
TIMESTAMPDIFF(unit, datetime1, datetime2)Parameter
unitkeywordwajib
The unit of the result (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, etc.)
datetime1DATETIMEwajib
The first datetime value (subtracted from datetime2)
datetime2DATETIMEwajib
The second datetime value
Contoh Penggunaan
Age in Years
SQL
1 SELECT TIMESTAMPDIFF(YEAR, '1990-05-15', CURDATE()) AS age;
Calculate age in years.
Hasil
age: 34
Hours Between
SQL
1 SELECT TIMESTAMPDIFF(HOUR, '2024-01-01 00:00:00', '2024-01-02 12:00:00') AS hours;
Difference expressed in hours.
Hasil
hours: 36
Days Since Order
SQL
1 SELECT order_id, 2 TIMESTAMPDIFF(DAY, order_date, NOW()) AS days_ago 3 FROM orders;
How many days have passed since each order was placed.
Hasil
(days since each order)
Pertanyaan Umum tentang TIMESTAMPDIFF
Apa itu fungsi TIMESTAMPDIFF di MySQL?
Calculates the difference between two datetime values in a specified unit. More flexible than DATEDIFF. Di MySQL, fungsi TIMESTAMPDIFF termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan TIMESTAMPDIFF di MySQL?
Gunakan sintaks berikut: TIMESTAMPDIFF(unit, datetime1, datetime2). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi TIMESTAMPDIFF?
Fungsi TIMESTAMPDIFF mengembalikan nilai bertipe BIGINT. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.
Fungsi Equivalen di Database Lain
Fungsi Terkait
Ngulik Langsung
Latihan Langsung →Sudah paham TIMESTAMPDIFF? Latih langsung di browser
Latihan interaktif, langsung di browser.