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

##</code><code>##

SELECT 1 
WHERE $my_date_time BETWEEN $start_date_time AND $end_date_time