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