Add 2 hours to current time in MySQL?

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

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

More Related Contents:

  1. How to get a ranking result for special record in mysql [closed]
  2. SQL Query needed for fetch value from Two identical table but not fully identical table
  3. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  4. How to reset AUTO_INCREMENT in MySQL
  5. MySQL Query GROUP BY day / month / year
  6. MySQL Server has gone away when importing large sql file
  7. How do I use on delete cascade in mysql?
  8. How to access remote server with local phpMyAdmin client?
  9. How to copy data from one table to another new table in MySQL?
  10. How to connect mysql workbench to running mysql inside docker?
  11. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  12. Calculate the time difference between of two rows
  13. What’s the difference between using INDEX vs KEY in MySQL?
  14. MySQL/Writing file error (Errcode 28)
  15. mysql select top n max values
  16. MySQL Group By and Sum total value of other column
  17. MySQL : Multiple row as comma separated single row
  18. MySQL Trigger: Delete From Table AFTER DELETE
  19. Return a default value if single row is not found
  20. How to find out the MySQL root password
  21. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  22. Removing duplicates with unique index
  23. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  24. How to restrict a column value in SQLite / MySQL
  25. Does MySQL foreign_key_checks affect the entire database?
  26. How to connect locally hosted MySQL database with the docker container
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment