DATE_DIFF

Calculates the difference between start_timestamp and end_timestamp by the indicated unit.

Syntax

DATE_DIFF('<unit>', <start_timestamp>, <end_timestamp>)

Parameters

Parameter	Description
<unit>	A TEXT literal specifying the time unit. Must be one of microsecond, millisecond, second, minute, hour, day, week, month, quarter, year, decade, century, or millennium.
<start_timestamp>	A value expression evaluating to a TIMESTAMP or TIMESTAMPTZ value.
<end_timestamp>	A value expression evaluating to a TIMESTAMP or TIMESTAMPTZ value.

Return Type

BIGINT

Example

SELECT DATE_DIFF('day', '2024-01-01'::TIMESTAMP, '2024-04-15'::TIMESTAMP);

Returns

105