DATE_DIFF
date_diff(part, startdate, enddate)
Section titled “date_diff(part, startdate, enddate)”- part: VARCHAR
- startdate: TIMESTAMP WITH TIME ZONE
- enddate: TIMESTAMP WITH TIME ZONE
Example
Section titled “Example”SELECT date_diff('hour', TIMESTAMPTZ '1992-09-30 23:59:59', TIMESTAMPTZ '1992-10-01 01:58:00');