Date & Time

MONTHS_BETWEEN

Snowflake

Menghitung jumlah bulan antara dua tanggal.

Tipe hasil: NUMBERDiperbarui: 6 Jan 2026

Syntax

SQL

MONTHS_BETWEEN(date1, date2)

date1DATE/TIMESTAMPwajib

Tanggal pertama

date2DATE/TIMESTAMPwajib

Tanggal kedua

SQL

1 SELECT MONTHS_BETWEEN('2024-06-15'::DATE, '2024-01-01'::DATE) as months;

Menghitung selisih bulan.

Hasil

5.451612903

SQL

1 SELECT
2   employee_name,
3   MONTHS_BETWEEN(CURRENT_DATE, hire_date) as tenure_months
4 FROM employees;

Menghitung tenure karyawan.

TIMESTAMPDIFF

MySQL

1	SELECT
2	employee_name,
3	MONTHS_BETWEEN(CURRENT_DATE, hire_date) as tenure_months
4	FROM employees;