mercredi 2 septembre 2015

Select all rows between two specific times across multiple days

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