Functions/Dates & time/to_months
Dates & time Scalar

to_months()

Construct a month interval

Arguments & returns

2 overloads

to_months(integer)

Scalar
Overload link integer Returns
#01 BIGINT INTERVAL
#02 INTEGER INTERVAL

Example

to_months example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Used in larger rewrites 1

These examples use to_months as one part of a larger SQL translation.

Snowflakeadd_months()

SELECT ADD_MONTHS('2016-05-15'::DATE, 2.7)
In DuckDB
SELECT CAST(CASE WHEN LAST_DAY(CAST('2016-05-15' AS DATE)) = CAST('2016-05-15' AS DATE) THEN LAST_DAY(CAST('2016-05-15' AS DATE) + TO_MONTHS(CAST(ROUND(2.7) AS INT))) ELSE CAST('2016-05-15' AS DATE) + TO_MONTHS(CAST(ROUND(2.7) AS INT)) END AS DATE)

SQLGlot example ↗