Add 2 hours to current time in MySQL?

SELECT * 
FROM courses 
WHERE DATE_ADD(NOW(), INTERVAL 2 HOUR) > start_time

See Date and Time Functions for other date/time manipulation.


You need DATE_SUB() OR DATE_ADD()


SELECT * FROM courses WHERE (NOW() + INTERVAL 2 HOUR) > start_time