mysql add hours to timestamp code example
Example 1: Add 2 hours to current time in MySQL
SELECT *
FROM courses
WHERE DATE_ADD(NOW(), INTERVAL 2 HOUR) > start_time
Example 2: mysql add hours to time field
ADDTIME(scheduled_date, '03:15:00')
SELECT *
FROM courses
WHERE DATE_ADD(NOW(), INTERVAL 2 HOUR) > start_time
ADDTIME(scheduled_date, '03:15:00')