mercredi 25 février 2015

SQLite comparing time values

I've got a time field (HH:MM:SS) in a table and need a query that limits results to all records where the time field is more than 3:00:00


Pretty sure I need to use the time() function somehow, but no matter what I try I either get an error or incorrect resultsets.



select * from table where time_happens > '03:00:00'


...doesn't give an error, but doesn't work correctly.


Aucun commentaire:

Enregistrer un commentaire