Hello all,
I have a table of work shifts. It has
Table "teams"
Attribute | Type | Modifier
------------+---------------+----------
team_id | varchar(50) |
team_name | varchar(100) |
location | varchar(100) |
department | varchar(100) |
shift | varchar(100) |
start_time | numeric(30,6) |
end_time | numeric(30,6) |
mon | boolean |
tue | boolean |
wen | boolean |
thu | boolean |
fri | boolean |
sat | boolean |
sun | boolean |
start_day | char(3) |
end_day | char(3) |
What I need to be able to do is select team_name where team works between a
time span ie teams that work between 730 and 1600 how would I do this????
What type of field should i sue for start_time and end_time?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
