Results 1 to 2 of 2

Thread: Calculus with hour

  1. Apr 24th, 2000, 11:18 PM #1
    mutley
    mutley is offline

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    Question

    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
    Reply With Quote Reply With Quote
  2. Apr 24th, 2000, 11:40 PM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    What DBMS are you using?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width