yki
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
within_dt_range(tz timestamp with time zone, after timestamp with time zone, before timestamp with time zone)
Parameters
Name
Type
Mode
tz
timestamp with time zone
IN
after
timestamp with time zone
IN
before
timestamp with time zone
IN
Definition
BEGIN RETURN (after IS NOT NULL AND before IS NOT NULL) AND (date_trunc('day', (after AT TIME ZONE 'Europe/Helsinki')) + time '10:00') <= tz AT TIME ZONE 'Europe/Helsinki' AND (date_trunc('day', (before AT TIME ZONE 'Europe/Helsinki')) + time '16:00') > tz AT TIME ZONE 'Europe/Helsinki'; END;