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   gt  start time   note  start time is a field of courses table

User · Answer

This will also work SELECT NAME  FROM GEO LOCATION WHERE MODIFY ON BETWEEN SYSDATE   - INTERVAL 2 HOUR AND SYSDATE

User · Answer

You need DATE SUB   OR DATE ADD

User · Answer

SELECT    FROM courses  WHERE DATE ADD NOW    INTERVAL 2 HOUR   gt  start time   See Date and Time Functions for other date time manipulation

User · Answer

SELECT   FROM courses WHERE  NOW     INTERVAL 2 HOUR   gt  start time

User · Answer

The DATE ADD   function will do the trick   You can also use the ADDTIME   function if you re running at least v4 1 1    For your query  this would be   SELECT    FROM courses  WHERE DATE ADD now    INTERVAL 2 HOUR   gt  start time   Or   SELECT    FROM courses  WHERE ADDTIME now     02 00 00    gt  start time

[mysql] Add 2 hours to current time in MySQL?

Examples related to mysql