> From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
> owner@postgresql.org] On Behalf Of Peter Jackson
> Subject: [NOVICE] Selecting time periods
> I've tried SELECT shift from shift_times where '17:00' between start
> AND finish;
> Which works for A and C but if I change the 17:00 to 19:30 it
returns
> no rows.
Just taking a guess here, but how about:
SELECT shift FROM shift_times WHERE '19:30' BETWEEN least(start,finish)
AND greatest(start,finish);
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
.now.