Suppose mytable
has two columns:
- date_time as TEXT (formatted as ‘%Y-%m-%d %H:%M’)
- 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