mysql NOW() with defined time

Question

I need to perform a mysql select query where date time field in table is less then todays date with a time of 2am.

How would I structure this

SELECT * FROM tbl WHERE datetimefield < (DATE(NOW()) and time 2am)

Thank you for any assistance.

Answer 1

SELECT * FROM tbl WHERE datetimefield < STR_TO_DATE(concat(curdate(), ' ', '02'),'%Y-%m-%d %H')

Answer 2

This worked:

SELECT * FROM tbl WHERE datetimefield < DATE_ADD(CURDATE(), INTERVAL 2 HOUR)

fiddle - in the fiddle I used a hard coded date '2013-05-04', so it would work correctly later.