Re: SQL query with Time

[Peter Brawley]

OK, as you're learning, SQL is a very awkward tool for computing times, eg
'00:00:00' is later than '23:59:59', so you have to handle multiple contingencies ...

...between starttime and 
   case 
     when endtime>=starttime then endtime
     when endtime<'12:00:00' then addtime(endtime,'12:00:00')
     when endtime='12:00:00' then '24:00:00'
     else subtime(endtime,'12:00:00')
   end...