Ei Maung Ei Maung - 3 months ago 8
MySQL Question

Add 2 hours to current time in MySQL?

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
SELECT * 
FROM courses 
WHERE DATE_ADD(NOW(), INTERVAL 2 HOUR) > start_time

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