DATE_DIFF

DuckDB

date_diff(part, startdate, enddate)

• part: VARCHAR
• startdate: TIMESTAMPTZ_NS
• enddate: TIMESTAMPTZ_NS

Example

SELECT date_diff('hour', TIMESTAMPTZ '1992-09-30 23:59:59', TIMESTAMPTZ '1992-10-01 01:58:00');