PDA

Click to See Complete Forum and Search --> : Calculus with hour


mutley
Apr 24th, 2000, 11:18 PM
I have an table wich have eg 2 columns, begin hour and end hour.
hour_ini hour_fim
07:00 07:15
07:16 07:30
07:31 07:45
07:46 08:00
08:01 08:15
08:16 08:30
08:31 08:45
08:46 09:00
interval

I have an event wich spend 20 minutes, and the users want after 8:45, How can I look , if have an hour vacancy for an SELECT

JHausmann
Apr 24th, 2000, 11:40 PM
What DBMS are you using?