MONTHS_BETWEEN

​

Syntax

​

Scalar

months_between(first, second [, round_off])

​

Arguments

​

Returns

• Type: DOUBLE
• NULL behavior: NULL temporal inputs yield NULL. NULL round_off uses TRUE.

​

Properties

​

Usage notes

• Same day-of-month or both month-end dates produce an integer difference, ignoring time-of-day.
• Otherwise fractions use a 31-day month and time-of-day difference.
• Supply a constant round_off flag. A column with different flags per row is outside this form.
• Deterministic: Fractional results use floating-point arithmetic and optional eight-decimal rounding.

​

Examples

​

Basic example

SELECT months_between(DATE '2024-03-15',DATE '2024-01-15') AS result;

​

Negative differences

SELECT months_between(DATE '2024-01-15', DATE '2024-03-15') AS months;

​

Limitations

• Calendar calculations use the timestamp’s stored UTC time. They do not adjust it to the timestamp’s named time zone.