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