PostgreSQLDate/Time FunctionsMAKE_INTERVAL
MAKE_DATE

MAKE_INTERVALDate/Time Functions

CLOCK_TIMESTAMP

Creates an interval from unit components.

Syntax

MAKE_INTERVAL([...units])

Example

Enter values below to update the example in real time.

months
three_months_later
SELECT NOW() + MAKE_INTERVAL(months => 3) AS three_months_later;