Suppose mytable has two columns:

  1. date_time as TEXT (formatted as ‘%Y-%m-%d %H:%M’)
  2. customer_ID as TEXT

Given the following data set:

date_time customer_ID
2014-02-05 00:17 003
2013-02-05 22:45 022
2014-02-05 00:33 053
2014-02-13 03:15 061
2014-01-29 17:40 064
2014-02-04 22:29 074
2014-02-05 00:10 082
2014-02-13 03:16 090

In this case, we can extract ID of customers who visited between from 22:40 to 00:30 by

SELECT customer_ID FROM mytable WHERE 
strftime('%H:%M', date_time) >= '22:40' OR 
strftime('%H:%M', date_time) <= '00:30';

resulting

customer_ID
003
022
082