Date & Time
Snowflake
TIMESTAMPDIFF
SnowflakeMenghitung selisih antara dua timestamp dalam satuan yang ditentukan.
Tipe hasil:
NUMBERDiperbarui: 6 Jan 2026Syntax
SQL
TIMESTAMPDIFF(part, timestamp1, timestamp2)Parameter
partstring literalwajib
Unit hasil: year, month, day, hour, minute, second
timestamp1TIMESTAMPwajib
Timestamp awal
timestamp2TIMESTAMPwajib
Timestamp akhir
Contoh Penggunaan
Days Between Timestamps
SQL
1 SELECT TIMESTAMPDIFF('day', '2024-01-01'::TIMESTAMP, '2024-03-15'::TIMESTAMP) as days;
Menghitung selisih hari.
Hasil
74