Basically what I want try to do is to get shift in range between

[![enter image description here](https://i.stack.imgur.com/eH683.png)](https://i.stack.imgur.com/eH683.png)

already get with this where 

```
where @param_value_from_hour between From_Hour and To_Hour

```

it works when @param\_value\_from\_hour let say 16:00 but what if I have to search @param\_value\_from\_hour with 19:00?