Add 2 hours to current time in MySQL?

Question

Which is the valid syntax of this query in MySQL?

SELECT * FROM courses WHERE (now() + 2 hours) > start_time

*note: start_time is a field of courses table*

Answer 1

You need DATE_SUB() OR DATE_ADD()

Answer 2

The DATE_ADD() function will do the trick. (You can also use the ADDTIME() function if you're running at least v4.1.1.)

Answer 3

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