Re: [SQL] SQL Query using time

[Blaise Carrupt]

> Is it possible to carry out the comparison in the following manner
> select name from table where 00:12 is between 23:58 and 00:30

You could try something like
WHERE ('00:12' BETWEEN startTime AND endTime 
       AND startTime <= endTime)
   OR ('00:12' NOT BETWEEN endTime AND startTime
       AND startTime > endTime)
       
Should work slower, but should work... And take care to equality with BEWTEEN.


____________
B. Carrupt