select 1 
where $my_date_time > $start_date_time 
and $my_date_time < $end_date_time

##</code><code>##


start | end
-----------
22:00 | 04:00


##</code><code>##


start | end_after_minutes
----------------
22:00 | 360