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

​
Syntax

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

​
Parameters

ParameterDescription
<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