vendredi 31 juillet 2015

Select all MySQL records in the last day that are between a time range of 7am and midnight

I have this query

SELECT * FROM `timeclock_timecard` 
WHERE `clock_in_datetime` > DATE_SUB(CURDATE(), INTERVAL 1 DAY)  

which can get record in the last day but I need to limit to records created after 7AM

Any help please?

Aucun commentaire:

Enregistrer un commentaire