I'm managing an SQLite database containing messages along with associated timestamps collected over the past month, and I wish to select all of the entries, for all days, between two given hours. In pseudocode style: SELECT * FROM Messages BETWEEN x AND y
, where x
might be 14:45 and y
15:45, and returning all the messages between x
and y
for all the days over the past month.
Is there a straightforward way of performing this in SQLite?
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire